Conditional formatting

[nparsons75]

Hi, I need to format a cell in the following way.

In column E (if this equals 'YES') but Column F = blank then the text YES in Column E should be RED.

In column E (if this equals 'YES') and Column F = contains text then the text YES in Column E should be GREEN.

Hope that makes sense.

 

[oldbrewer]

in E1 put =and(E1="YES",F1="")=TRUE set red

then a second condition

in E1 =and(E1="YES",F1<>"")=true set green