Conditional Formatting multiple criteria

[Szucchari]

Hi, I need to use conditional formatting to highlight a blank cell based on several criteria in other cells. I do not know if I should do all the criteria separately or do a nested IF. But either way, I cannot get it to work.

C	D	E
date assigned	date completed	TAT
7/25/2021

if D3 is blank and today is 2 or more days past C3 then D3 should highlight in red. But if D3 has a date listed it goes back to no fill/ white.

 

[steve the fish]

Try this:

=AND(D3="",TODAY()-C3>1)

 

[Szucchari]

Try this:

=AND(D3="",TODAY()-C3>1)

Thank you for helping! Unfortunately the formula is only highlighting the rows with no data in it.

 

[steve the fish]

Then you have implemented it wrongly or your dates arent really dates or maybe are date times. It works as i tested it.

 

[Szucchari]

Then you have implemented it wrongly or your dates arent really dates or maybe are date times. It works as i tested it.

Okay, I will play around with it thank you for your help.