conditional format date range

[EMcK01]

Hi,

I have date in cell A3 that forms a simply calendar for any give month starting on a Monday from C6:I11. To ensure I get the full month it covers 42 days so will always have a few dates from the previous and following months.

I am using conditional formatting to grey out days out with the calendar month with

=MONTH(C6)<>MONTH($A3)

however this only works for row 6. I need to repeat the rule for rows 10 & 11.

Is there a formula that can be used that covers the range from C6:I11?

Thanks

 

[iggydarsa]

Would this help?

- Copy a cell that works properly
- Highlight all your cells that make up your calendar
- Right click and from the popup select Paste Special > Formatting

 

[EMcK01]

Hi,

thanks for the response. Unfortunately that doesn't work, it highlights dates that shouldn't be included.

 

[iggydarsa]

Is A3 actual part of the calendar or just a driver to create a calendar?
if it is a driver try changing your formula to =MONTH(C6)<>MONTH($A$3) and try the steps above again.

 

[EMcK01]

Is A3 actual part of the calendar or just a driver to create a calendar?
if it is a driver try changing your formula to =MONTH(C6)<>MONTH($A$3) and try the steps above again.

Yes A3 is the driver to change it, and that works perfectly.

Thanks, much appreciated