View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
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.