Posted to microsoft.public.excel.newusers

Tracy[_3_] Tracy[_3_] is offline

external usenet poster

Posts: 3

conditional formating

I have a spreadsheet with a column of dates from the past to the future. How
can I format the cells so that the dates previous to today have a colour in
the cells?

Thanks, Tracy

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
conditional formating	Paul	Excel Discussion (Misc queries)	1	March 31st 08 10:36 AM
Conditional Formating	carl	Excel Worksheet Functions	4	September 5th 07 07:31 PM
Conditional Formating	Zee	Excel Discussion (Misc queries)	5	August 10th 06 02:56 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional Formating	kpekarek	Excel Worksheet Functions	2	August 17th 05 03:41 PM

All times are GMT +1. The time now is 05:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us