Change row color according to cell entry

[RPT_22]

Hi,

Could someone help me with the following please? Can this be achieved without VBA?

1. If i place YES in cell N4, it then colors the row B4: P4 amber
2. If i then place YES in cell O4, it then colors the row B4: P4 red
3. If i then place YES in cell P4, it then colors the row B4: P4 green

This will cover a range the B4:P150

Thank you

RPT

 

[SanjayGMusafir]

Use 3 condition formatting rules as below for range B4:P150

for Amber

=$N4="Yes"

for Red

=$O4="Yes"

for Green

=$P4="Yes"

 

[RPT_22]

Thanks Sanjay

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.