can I change font color for a date which is appoaching to act as

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I am using Excel and have added a date to a cell. I want to set up some form
of alert on an impending date and wondered whether I could arrange for the
date to change font colour "x" number of days before the date.

Regards
 
hi
conditional fomating.
on the menu bar..
format>conditional formating
cell value is........less than........=now()-7....pick your format.

for this example, i chose 7(days). change it if needed.

Regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Font Color on Dates 1
textbox font colour 2
Access How to record date/time when specific field is modified in Access 2007 0
Excel Formatting with dates 3
Change color of font base on time range 2
Using CF to change colour in cell based on date? 4
Conditional Formatting Font Change 1
Change default font color for a single spreadsheet? 10

Back
Top