View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Conditional Format via Macro?

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!