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?
(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?