Forum Discussion
Excel Condtional Formatting using Formula
First time poster. Please redirect me as necessary. I know how to use Formulas in Conditional Formatting, but I have a question about the structure of the formula. Why does the formula begin with...
craigbragg wrote:
Range A1:A5
Want to format cells with values greater than 2
Formula =A1>2
Why isn't the formula =A1:A5>2
Because you want to compare only A1 in cell A1 and do not want to compare A1:A5 in cell A1.
The formula always works for one cell and is copied in memory to the other cells (A2:A5).
Thank you Detlef.
