Thanks, Everyone! I think perhaps I didn't give enough information. My
apologies.
In cell A1 I have the current month (March).
In columns B through M, I have various formulas and values - and each column
header is a month (B1 is January, B2-B100 is the information for January),
etc. Is it possible to have Excel highlight the entire column for March (or
whatever month is listed in cell A1)?
--
Thanks for all you do!
"Max" wrote:
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!