Conditional Format

[MikeDBMan]

I need to have a conditional format where:
(If the contents of Column E on that row has a Y
OR
the contents of Column F has a Y)
AND G on that row is empty, then G is colored.

I have tried this and the formula has errors:
=or(E2=Y, F=Y) and G=""

This one gives me an error also:
=or(E2="Y",F2="Y") and G2=""

Suggestions?

 

[Marcelo Branco]

Try

=AND(OR($E2="Y",$F2="Y"), $G2="")

M.

 

[MikeDBMan]

Marcelo, I was just about there myself but you helped me greatly! Thanks so much. I have already distributed my file to users all over the globe!

 

[Marcelo Branco]

Marcelo, I was just about there myself but you helped me greatly! Thanks so much. I have already distributed my file to users all over the globe!

Wow... all over the globe!

You are welcome.

All the best

M.

 

[MikeDBMan]

Had to chuckle! Just Germany, Canada and the US. Not exactly "All" over. Anyway, I appreciate your help!