Conditional formatting: One cell based on the value of another

Hi all,

I am attempting to apply conditional formatting such that cell B3 is green if it is greater than or equal to cell B2, and red if less than cell B2. Then to apply this conditioning across the row of data (i.e. C3 >= C2 green, C3 < C2 red; D3 >= D2 green, D3 < D2 red; E3 >= E2 green, E3 < E2 red ... etc.).
Needs to be formatted such that if I change the value in cell B2, the colour of B3 is automatically updated.


Please find attached an example worksheet.


Thank you for your time and assistance.

hello,

1.select cells B3:E3
2. click on HOME -> conditional formatting - > new rule
3. activate option 'use a formula to determine which cells....'
4. write following formula below:

'=b3<b2' and click button to set the format (font color red) - this the way to determine the format of cells.

If You want to define second rule (font color green) You must repeat steps (3-4) but in step number 4 write formula "=b3>=b2" and set another formatting of cells.

regards.

Thank you each for your time.

Andrew, spot on, thank you very much.

This info help me as well, thanks. I have a similar poser. I've managed to conditionally format an entire row based on the info in one cell, but I would like to apply the same rules to all rows individually. In other words, if the value in E2 is charge, then format the entire row red BUT if the value in E3 is prepay then format the entire row blue, etc. How would I do this without creating a new rule for each row?