conditional formatting

[Holly710]

I'm trying to conditionally format an excel sheet. I have 12 columns and 11 rows; I want each cell to compare to the previous cell in that row. If the value is higher, the font is green; if the value is lower the font is red; and if the value is the same, the font is blue. I can make it work for the first column but if I try to continue it across all columns, it always compares to the original cell in column A. How can I set it up to always compare the cell to the immediate left (e.g. compare cell in Row 1, Column C to cell in Row 1, Column B; then compare cell in Row 1, Column D to cell in Row 1, Column C, etc) ?

[#2 · Accepted solution]

Hi @Holly710 

It seems you are using absolute reference in the formula, you will find the $ and you have to remove it.
You can remove it manually, or by pressing F4

* If my post helped you, please click on like.

[#3]

@Jihad Al-Jarady 

perfect! Problem solved - thanks so much!