Forum Discussion
Solved
Conditional Formatting Question
I have numerical data that exists in many rows and columns. I'm looking for a way to highlight values in each column lower than the value in the first row of each column. It's easy enough to do with ...
- so conditional formatting uses $ and no $ as absolute and relative references accordingly so in this case you formula should be something like:
=A2<A$1
Where A2 is the upper left corner of the Applied To range and notice the $ is only on the 1 and not the A so as excel moves to different column the column reference change also but the row (row 1) will stay the same. Adjust accordingly
so conditional formatting uses $ and no $ as absolute and relative references accordingly so in this case you formula should be something like:
=A2<A$1
Where A2 is the upper left corner of the Applied To range and notice the $ is only on the 1 and not the A so as excel moves to different column the column reference change also but the row (row 1) will stay the same. Adjust accordingly
=A2<A$1
Where A2 is the upper left corner of the Applied To range and notice the $ is only on the 1 and not the A so as excel moves to different column the column reference change also but the row (row 1) will stay the same. Adjust accordingly
