Forum Discussion
How to colour a row automatically based on a cell value
Hi Excelers, How to set a colour to a row/range, say B4:B16, when B5 is a particular value, say <0.0.
=B$5<0It works with this rule for conditional formatting in my sheet.
=$B$4:$G$16This is the applies to range in the example.
With this rule and "applies to" range you can highlight range B4:B16 if B5<0 and highlight range C4:C16 if C5<0. This works accordingly up to range G4:G16 if G5<0.
Thanks OliverScheurich, I also found yet another answer in a post in this community, which exactly matched my requirement. Happy to be here with you all and thanks again for your time and effort.