GregR

Posts: n/a

Conditional Format Holidays

I have a worksheet with holidays listed in M2:M12. I want to conditionally
format a cell if the date is a holiday. Additionally, if the holiday falls
on Sat, I want the previous Fri. formatted and if the holiday falls on Sun,
the following Mon. TIA

Greg

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 format of data tables in charts	[email protected]	Charts and Charting in Excel	2	January 25th 05 03:56 PM
copy conditional format as ACTUAL format	Dana Zulager	Excel Discussion (Misc queries)	7	December 7th 04 11:02 PM
deleting a conditional format	[email protected]	Excel Discussion (Misc queries)	4	December 7th 04 10:45 PM
make a conditional format the default	Fred Evans	Excel Discussion (Misc queries)	3	December 6th 04 05:01 AM
Conditional format	rexmann	Excel Discussion (Misc queries)	4	December 2nd 04 12:01 PM

All times are GMT +1. The time now is 05:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us