Conditional Formatting dates

cuzz

New Member
Joined
Jan 18, 2005
Messages
4
Hello to all

Newbie question here.

I do the tracking of disciplinarian action for employees. The majority of the employees are not on any warnings, but some are :oops: . On my spreadsheet I have the drop off date. What I want is when the date arrives ( their warning expires) is to turn red to alert me that I need to advise them they are off their warning. I have come up with the following:
Condition 1 Cell value is less than or equal to =today() format color red
Condition 2 Cell value is greater than or equal to =today() format color white

My problem is when I use format painter the cells that have no date also turn red, and I would like to keep them clear until a drop off date is supplied (if necessary). Any and all help is greatly appreciated.
TIA :pray:
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,148,215
Messages
5,745,424
Members
423,951
Latest member
peggrif

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