Joooooooo

Posts: n/a

conditional formatting overdue dates

Hi - I have a worksheet with a column (m7:m40) containing dates of reviews
that have taken place. I want to conditionally format it so the dates that
are a year ago or more are highlighted - any idea how to do this? Many thanks

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
Determine cells that drive conditional formatting?	Nicolle K.	Excel Discussion (Misc queries)	2	January 7th 05 01:08 AM
Conditional formatting not available in Excel	BAB	Excel Discussion (Misc queries)	2	January 1st 05 03:33 PM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM
How do I get more than 3 Conditional formatting?	TSgt Ed	Excel Discussion (Misc queries)	1	December 29th 04 07:04 PM
Conditional Formatting for dates	spacerocket	Excel Worksheet Functions	2	November 4th 04 10:13 AM

All times are GMT +1. The time now is 01:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us