Conditional Formatting - how to leave blank cells blank - no colour until date populated

hi

Please see attached file - I have 3 conditional formatting formulas in place. But the red cell which should be any cells with a date of today and -1day. All cells in this range are going red - I want blank cells not yet populated to remain white/blank/no formatting

can you help please

thanks
leanne

Hi

Thanks but when I put =AND($C$2<>"",$C$2>=NOW(),$C$2<NOW()+90) I now get yellow blank cells instead of red.
IF I put D2 instead of C2 like you said then cell c2 (with a date) goes white ??

See attached file - thanks

Hi

Can anyone help with my post ?

Thanks
Leanne