Conditional formatting of blank cell based on date in adjacent cell

eabaker64

New Member
Joined
Jul 1, 2024
Messages
35
Office Version
  1. 365
Platform
  1. Windows
Hi. I am having an issue with conditional formatting. I have a date in P9. Q9 is blank. I would like Q9 to display yellow fill if the date in P9 is within 14 days. If it is over 14 days, I would like the fill in Q9 to show red. I have conditional formatting as such that applies to =$Q$9: Formula: =AND(Q9="",TODAY()>P9) with red fill; =AND(Q9="",(TODAY()+14)P9) with yellow fill. In the conditional formatting rules manager, I have the red fill first and the yellow fill second. However, even when the date in P9 is within 5 days of today, it still shows as red, as does any other dates entered in P9. If I switch them around to where the yellow rule is first, every date entered in P9, even if it is 3 months old, shows as yellow. What am I doing wrong? Thanks in advance.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Try this:

1723576879683.png


Proof:

1723576901175.png
 
Upvote 0
You are welcome.
Glad I was able to help!
 
Upvote 0

Forum statistics

Threads
1,224,595
Messages
6,179,798
Members
452,943
Latest member
Newbie4296

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top