How to colour a row automatically based on a cell value

[ShanShines]

Hi Excelers,

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

[#2]

@ShanShines 

=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. 

[#3]

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.