Conditional Formatting

[James__S]

Hi

What formula would i insert into the "Use a formula to determine which cells to format" for conditional Formatting

I highlighted range B3:F3 which i want to turn Green if the following is True. I used the following formula

=AND(D3="YES",E3="YES",F3="YES")

The only Cell green is B3. I need to highlight B3:F3 if true Green or RED if False

Thanks
JS

 

[63falcondude]

If you want to highlight B3:F3 in Green if =AND(D3="YES",E3="YES",F3="YES") returns TRUE and highlight B3:F3 in Red if =AND(D3="YES",E3="YES",F3="YES") returns FALSE, try this:

Highlight B3:F3 > Conditional Formatting > New Rule > Use a formula
=AND($D3="YES",$E3="YES",$F3="YES")
Format: Fill Green > OK > OK

Highlight B3:F3 > Conditional Formatting > New Rule > Use a formula
=AND($D3="YES",$E3="YES",$F3="YES")=FALSE
Format: Fill Red > OK > OK

 

[James__S]

Thank you

What would i need to add to the formula that if the range B3:F3 is blank. If blank/no text than that range is white

If say have it formatted Red and remove all the text the range B3:F3 will still remain Red

Thanks

 

[63falcondude]

You're welcome.

Change that second formula (the red formula) to this:

=AND(AND($D3="YES",$E3="YES",$F3="YES")=FALSE,COUNTBLANK($B3:$F3)<>5)

 

[James__S]

Many thanks 63falcondude

 

[63falcondude]

You're welcome. Happy to help.