Hi all,

I am trying to highlight a blank cell as a reminder to the user to perform an action with an approaching due date (based on multiple conditions).

My active cell (the potentially blank cell) is G5. I need the formula to only highlight G5 red if all of the following are true:

1. G5 is blank
2. the value in B5 is equal to the letter "C" (this is a text cell)
3. today's date is within 45 days of a year after the date entered in cell D5 (this is a client intake date and is the basis for all of the due dates in the row, and the target action must be performed within 365 days of that initial date).

I was trying to piece together various rules I had seen from other threads. I'm currently working with what is shown below, but of course it's not working. Any ideas? Thank you in advance for any assistance you can provide.

=AND($B$5="C",$D$5="",D5<=(TODAY()-320))