Help with CF

[Spraggs]

Good morning all,
I'm using Vista & Excel 2007

I want to enter a Conditional format that will...
A. If C2= "" then no fill
B. If C2=Y and Q2="Pass" then format green fill.
C. Any other combination, then fill red.

This may also be used by users with excel 97-2003.

Cheers Jase

 

[Aladin Akyurek]

Good morning all,
I'm using Vista & Excel 2007

I want to enter a Conditional format that will...
A. If C2= "" then no fill
B. If C2=Y and Q2="Pass" then format green fill.
C. Any other combination, then fill red.

This may also be used by users with excel 97-2003.

Cheers Jase

Condition 1 (Green)

=AND($C2="Y",$Q2="Pass")

Condition 2 (Red)

=AND($C2<>"",$C2<>"Y")

 

[Spraggs]

Thank you Aladin.

 

[cpg84]

Good morning all,
I'm using Vista & Excel 2007

I want to enter a Conditional format that will...
A. If C2= "" then no fill
B. If C2=Y and Q2="Pass" then format green fill.
C. Any other combination, then fill red.

This may also be used by users with excel 97-2003.

Cheers Jase

2 conditional formatting needed:

1st: =if(and(C2="Y",Q2="Pass"),true,false) - make formatting "green fill"
2nd: =if(not(C2=""),true,false) - make formatting "red fill"