Posted to microsoft.public.excel.misc

Chas2

external usenet poster

Posts: 3

Conditional Formatting Dates

Help! I have a column showing installation dates being entered as mm/
dd/yy but is formatted to show the date as Monday, February 4, 2008. I
want to have any cell showing "Sunday" to be highlighted in a
different colour. I haven't been able to find a solution forr
conditionally formatting cells that contain "Sunday" Any suggestions?

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 Formatting - Dates	Ali Cat	Excel Discussion (Misc queries)	2	December 6th 07 09:15 AM
Conditional formatting dates	Contracto	Excel Discussion (Misc queries)	2	April 10th 07 07:52 AM
Conditional Formatting-dates	Eva	Excel Worksheet Functions	6	December 12th 06 10:20 AM
conditional formatting dates	Phil	Excel Discussion (Misc queries)	6	July 24th 05 09:18 PM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM

All times are GMT +1. The time now is 07:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us