Conditional Format

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
586
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?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
586
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!
 

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
586
Had to chuckle! Just Germany, Canada and the US. Not exactly "All" over. Anyway, I appreciate your help!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,906
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top