# Excel Conditional Formatting : Change Cell Colour Based on Value of Another

For each cell value I would like to change the colour in an adjacent cell based on the value in another. For example: I have a column of cells with a range on numbers from 81 to -91. Where cell values are between -30 and -91 the colour is RED Where cell values are between 0 and -30 the colour is AMBER Where cell values are between 1 and 81 the colour is GREEN

• You might try search the internet for "Excel between". – BillDOe Sep 30 '18 at 19:32
• the challenge is to put "to change the colour in an adjacent cell based on the value in another" relative equation in the rule.. – p._phidot_ Oct 15 '18 at 21:30 I think this is what you wanted. Basically, in Excel you can reference cells in different ways. You may sometimes realise that when you click on a cell to reference it in your formula, it's inserted as `\$A\$2` instead of `A2`. While both are correct, if for instance you start to drag around the former, the formula will be copied directly (e.g if you drag it to `A3` it will not change, but remain as `\$A\$2="Hi"` in both cells). If you do the same to the latter, the formula will adapt (e.g if you drag it to `A3` it will change from `A2="Hi"` to `A3="Hi"`). Also note that it is possible to only use one dollar sign/locked reference, such as \$A3 (where it will change when dragged on the Y axis, but not the X) or A\$3 (where it will change when dragged on the X axis, but not the Y).
In conclusion, make three formulae, all on the same range (the one you want to be coloured). The first, `=\$A2>0`, and set the format to have a green fill. The second, `=AND(\$A2>-31, \$A2<1)`, and have an amber fill. Finally, do `=\$A2<-30` with a red fill.