Forum Discussion
Conditional Formatting on whole column with variable reference cells
Hi, I'd like to format the colour fill of multiple cells within one particular column, when it's value is less than a cell in the row above of the next column. how should I do this please? eg....
Thanks Sergei. It works for the first cell. But when I try to copy and paste to apply the same formatting to to other cells within the same column, it doesn't work, as it is still comparing to the first cell.
What should I do, to apply the same conditional formatting for other cells, which it will compare accordingly?
You use another rule. Please use
add formula to the rule
=S140 >= R140applied to the range
$S$140:$S$145On practice first select range, add new conditional formatting rule , select type of the rule, add formula for the first cell of range correctly using relative references, apply format.
rech_yp , glad to help.
All the best for coming year!
- Thanks Sergei.. I got it! Happy new year!