Feb 23 2023 08:27 AM
Hi Excelers,
How to set a colour to a row/range, say B4:B16, when B5 is a particular value, say <0.0.
Feb 23 2023 09:05 AM
=B$5<0
It works with this rule for conditional formatting in my sheet.
=$B$4:$G$16
This 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.
Feb 25 2023 03:00 AM