Complicated conditional formatting

[BJSinger7623]

Hello! I need some help with some complicated conditional formatting please. I can get it to ALMOST do what I want, but because of the blank cell formatting it's always red and I'm hoping it will only turn red when certain conditions are met and remain white/blank until information is put in.

Here's what I need:
When there is a date in PRD, but nothing in 1st contact - the row to be red.
When there is a date in PRD and in 1st Contact - the row to be yellow.
When there is a date in all 3 (PRD, 1st Contact, and Initial) - the row be green.

I've gotten it to do that - but because of the blank for red, every row without anything in it is red - I want just a regular/blank sheet until I type something in - does that make sense?? Any help would be GREATLY appreciated!!!

Thank you!

 

[Fluff]

What are the formulae you are currently using?

 

[BJSinger7623]

What are the formulae you are currently using?

I was thinking (and tried playing around with) an AND formula - something like if there is text in Column C AND a blank in Column D it would turn red (that way the whole sheet wouldn't turn red), but I couldn't get it to work. I'm very basic with Excel.

 

[Fluff]

Thanks for that, for red you can use

=and($C2<>"",$D2="")

 

[BJSinger7623]

Thanks for that, for red you can use

=and($C2<>"",$D2="")

You are seriously incredible!!! Works like a CHARM! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.