LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 519
Default Conditional Formatting Rules Manager Excel 2007

Hello from Steved

In Conditional Formatting Rules Manager is it possible to ask to look for
6-feb and color the text Red and the background White I use this formula to
build my Calendar
{=IF(MONTH(D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx)=MONTH(D3),D3-DAY(D3)+1-WEEKDAY(D3-DAY(D3)+1)+Mtx,"")}

Others to look for would be the first Monday in June ( Holiday ) and the
second to last Monday in October ( Holiday )

Thankyou.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Exporting conditional formatting rules Chadwill Excel Discussion (Misc queries) 16 April 30th 23 03:43 AM
Suggestion: Excel 2007- New Conditional Formatting Rules and Optio Mr. Low Excel Discussion (Misc queries) 0 September 16th 07 10:46 AM
More than 3 rules of conditional formatting Mats K[_2_] Excel Discussion (Misc queries) 2 July 3rd 07 12:25 PM
Combine Conditional Formatting Rules formulae Fred Excel Discussion (Misc queries) 3 March 16th 07 02:27 AM
I need 5 conditional formatting rules-excel only allows 3 das1997 Excel Discussion (Misc queries) 4 November 12th 05 02:33 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"