This assumes you have real dates in A1, and in B3:M3
Select B3:M3 (B3 active), then apply the CF using the formula:
=MONTH(B3)=MONTH($A$1)
Format to taste, OK out.
This will format only the col header.
If you want to format the entire range, not just the col header in B3:M3
Select B3:M100 (B3 active), then apply the CF using the formula:
=MONTH(B$3)=MONTH($A$1)
Format to taste, OK out.
(assuming your range is row3 to row100)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jim" wrote:
I have a spreadsheet with the current month (March) in cell A1. I have a
column for each month within the spreadsheet.
For example: A1 = March. B3:M3 = January-December.
I want to create a macro (or conditional formating, if possible) that will
change the fill and font colors of the month's column that is listed in A1.
Is this possible? Thanks!