View Single Post
 
Old 11-21-2019, 10:44 AM
PrincessApril PrincessApril is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row

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))
Reply With Quote