Conditional Formatting - columns that are NOT current month

[eemiller1997]

I would like to format specific columns if their header cells do not contain the current month's date.

In the screenshot below, columns N-Q are hard-coded with the grey formatting because in June those were the two columns that were from may. But, in July the "Orphan Week" as I've dubbed it, should be greyed out. I would like to make this automatic rather than me hard-formatting it.

I've tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

neither of which work. What is the trick here?

FYI: N3 is the only cell hard-coded with 6/27/17. P3 has =N3+1, etc. N4 and O4 have =N3, P4 and Q4 have =P3, etc.Typically, line 4 is hidden, but I revealed it in case for clarity o this question.

Thank you.

format-non-current-month-columns1.jpg

format-non-current-month-columns2.jpg

[protonLeah]

=Month(N$3)<>Month(Now())

[eemiller1997]

=Month(N$3)<>Month(Now())

That looks great, thank you. I do have two things I need to adjust in that formula.

1. I need the N$3 to cover two cells at a time because I want the pair of columns to be formatted at a time. Since N3 is merged, I need to use N4 and O4. When I tried N4:O4 that the entire highlighted section formatted.
2. Instead of Now, I would like to specify the month. Would this be Month(7).... instead of Month(Now())?

Thanks again.

[JeteMc]

As for #1 try the following formula as a conditional formatting rule:

Please Login or Register  to view this content.

Note: the formula references M5 which is populated by a date (7/1/2017) and formatted 'mmmm'.
As for #2 the argument for month needs to be a date which Excel stores as days starting with Jan 1, 1900, so if you use the number 7 Excel will take that to mean the month of Jan 7, 1900 which would be Jan. This is why I had the formula reference cell M5, so that you wouldn't have to keep changing the formula. Of course you could reference any cell, or you could 'hard code' the formula putting in =MONTH(DATE(2017,7,1))
A spreadsheet with the aforementioned setup is attached. Test by changing the date in M5 to 6/1/17 and see if it is doing what you want.
Let us know if you have any questions.