Forum Discussion
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...
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.
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.
perfect! Problem solved - thanks so much!