Conditional formatting with date range

Rock5150

New Member
Joined
Nov 16, 2012
Messages
38
Office Version
  1. 365
Platform
  1. Windows
Hello all,

I have a spreadsheet where i need to color code the Date Uploaded cells with either green, yellow, or red. Green are documents uploaded 1-14 days post-approval (column A), yellow is 15-21 days post-approval, red is 22+ days post approval. I'm struggling trying to get the today date to format correctly with the date uploaded. for example the first two rows show "red" however these should be "green

Book1
B
7
Sheet1


This is a coworker's spreadsheet and the formula for C2 for conditional format is =AND(IF(ISBLANK(A2)=FALSE,B2<>"YES"),A2<TODAY()-30
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Rock5150

New Member
Joined
Nov 16, 2012
Messages
38
Office Version
  1. 365
Platform
  1. Windows
Book1
ABC
1Final Approval DateUploaded to PDMSDate Uploaded
21/8/2021Yes1/21/2021
32/8/2021Yes2/19/2021
412/9/2020Yes3/2/2021
53/29/2021Yes4/7/2021
63/17/2021Yes4/1/2021
Sheet1
 

Rock5150

New Member
Joined
Nov 16, 2012
Messages
38
Office Version
  1. 365
Platform
  1. Windows
Follow up: The color formatting needs to be in column C
 

Watch MrExcel Video

Forum statistics

Threads
1,129,588
Messages
5,637,275
Members
416,963
Latest member
samfuge

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
Top