Conditional Format Question

[treeleaf20]

All,
I'm trying to do some conditional formatting question. Say I have two columns C and D. I'm trying to format cell D3. I want the box to show up Red if C3 has a Y as the value and D3 has a N as it's value. What is the best way to accomplish this?

 

[WinteE]

Instead of using 'Cell value is' you have to use 'Formula is'. Enter the following formula

=AND(C3="Y";D3="N")

 

[treeleaf20]

I needed to take out the semi colon and replace it with a comma but that worked. Thanks.