Alerting for a due date

GE

New Member
Joined
Oct 25, 2002
Messages
8
I posted this earlier in the week but unfortunately the fixes proposed did not work.

I have a cell with a due date which i want to alert me by changing colour when the date is reached.
EG. date due is 1/1/03,so i want the cell to turn red on that date. If possible i would also like a pre alert of say 5 days before this time by turning green.

Thanks
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi

These many ways to do this maybe the simplist way would be to look at the conditional fromatting of the cell or range of cells, format to RED fill if greater than the date you want,


HTH

Kind regards
Jack
 

GE

New Member
Joined
Oct 25, 2002
Messages
8
Jack, i am a bit of a novice at this, could you give me a little more info.

Thanks
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi

WkBk sent the work book to you, all i ask is you report back on the board how thinks went

These an image on sheet 2 to show beter and copy that.

Jack
 

Forum statistics

Threads
1,144,116
Messages
5,722,568
Members
422,447
Latest member
srclife

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