make a cell contents flash in a color after a certain date

waynetrim

New Member
Joined
Nov 4, 2002
Messages
8
I would like to add to my excel spreadsheet
a feature where after a 15 days that the cell
would turn RED and hpefully flash to alert you that this information is aged.
use example:
I have customers who I promise to complete
the work promised in 15 days or less. If the account gets to past 15 dyas then there would be a penalty. If the spreadsheet could be set up as explained above then a past due account would be very easy to spot.
thanks everyone for your help.
Waynetrim
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi welcome to the board!

You can get what you need (not the flashing bit though) using conditional formatting. Check it out in the help files, search here for examples, post back with a littl emore info about how your sheet is set up if you need.

I'd also suggest having 2 or 3 conditions - completed, less than 3 days to go, overdue - something like that. No good being told when it's already too late!

oaddy
 

Watch MrExcel Video

Forum statistics

Threads
1,123,382
Messages
5,601,311
Members
414,441
Latest member
KellyTheKid

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