How to colour a row automatically based on a cell value

Occasional Contributor

Hi Excelers,


How to set a colour to a row/range, say B4:B16, when B5 is a particular value, say <0.0.

2 Replies



It works with this rule for conditional formatting in my sheet.


This is the applies to range in the example.

conditional formatting.JPGWith 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 @Quadruple_Pawn, 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.