Posted to microsoft.public.excel.newusers

jvmn

Posts: n/a

formula to change color of a cell when date is over a year old?

I'm looking for a formula to change dates that I have in a row once they are
over a year old.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
holiday dates	bucci	Excel Worksheet Functions	4	June 15th 06 09:35 AM
Change Year Date In A Formula Throughout The Spreadsheet	Autumn Dreams	Excel Discussion (Misc queries)	3	June 3rd 06 02:12 AM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Need to use IF formula with a Date cell	Eric Mc	Excel Worksheet Functions	2	June 8th 05 12:38 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM

All times are GMT +1. The time now is 10:57 AM.

About Us

"It's about Microsoft Excel"