The following table represents the value I’m working with in Microsoft Excel.

```
+---+----+-----+---------+-----+
| | A | B | C | D |
+---+----+-----+---------+-----+
| 1 | | Min | Current | Max |
| 2 | LF | 8 | 13 | 20 |
+---+----+-----+---------+-----+
```

I would like the value located in the current column to change color, based on whether it’s low, medium, or high, compared to the minimum & maximum possible value.

First what I do is determine the difference between the max and minimum values; in this case d3 – a3 = 12.

From there the first 1/3, or 33% of the value 12, is the “low” range.

I was able to use Excel’s “conditional formatting” and generate the following formula under ‘New Rule’ → ‘Use a formula to determine which cells to format’:

1st rule for “low values” whose cell will be filled with a certain color; they range from 8 to 12:

```
=$C2<ROUNDUP(($D2-$B2)*0.33, 0)+$B2
```

2nd added rule for “high values”, i.e. range from 17-20:

```
=$C2>$D2-ROUNDUP(($D2-$B2)*0.33, 0)
```

3rd added, is for “medium values”, that don’t belong to neither high nor medium:

```
=OR($C2>=ROUNDUP(($D2-$B2)*0.33, 0)+$B2, $C2<=$D2-ROUNDUP(($D2-$B2)*0.33, 0))
```

I went to 3 other cells, and set each of those cells to the color I want the “low”, “medium”, and “high” ranges to be filled with.

I would like the "conditional formatting" configuration to utilize the colors, designated to one of those 3 corresponding cells, in case in the future I decide to use different colors; it will be quicker to make that transition, rather than go to each individual cells to make that color change.