Linking a spreadsheet to calendar dates
Linking a spreadsheet to calendar dates
(OP)
Is there a way to link an excel spreadsheet to a calendar date?
For example, have a cell turn red on a specific date?
Or even better, turn yellow five days BEFORE the "red" date?
I'm thinking of recurring tool calibration cycles.
For example, have a cell turn red on a specific date?
Or even better, turn yellow five days BEFORE the "red" date?
I'm thinking of recurring tool calibration cycles.





RE: Linking a spreadsheet to calendar dates
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Linking a spreadsheet to calendar dates
Use conditional formatting with Use Formula:
=A1>today()-10
This assuming your date is in A1. Keep the cell reference relative and you can paste this with the Format Painter to other cells.
Why an easy solution if you can make it complicated?
Greetings from the Netherlands