Forum Discussion

Holly710's avatar
Holly710
Copper Contributor
Dec 19, 2020
Solved

conditional formatting

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) ?

  • 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.

2 Replies

  • 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.