Conditional Formula - highlighting month column based on todays date

**frogboy** · 11-08-2012, 08:43 AM

Hi I have 12 columns with the months in the e.g. Jan to Dec (K3:V3) and also have todays date in A1. Basically I would like to highlight the column that corresponds to the current month.
For example. Todays date is 8/11/12 (A1) so I would like the column under "Nov" to be highlighted RED. I have sort of set this up however it only highlights the column if I physcially type in "Nov" in cell A1.
If I put in =TODAY() in cell A1 which returns todays date then the conditional formula doesnt work unless I type in "Nov"
Hope this makes sense and I can get an answer. cheers

**TheExcelphile** · 11-08-2012, 08:50 AM

In a blank cell somewhere, say Z1, put the following formula:

=INDEX(K3:V3,1,MONTH(A1))

This will give you the corresponding month for today's date. Use this cell for your conditional formatting instead of using A1 directly.

Don't forget to click the little star to the left of this post if you feel I helped!

**Fotis1991** · 11-08-2012, 09:02 AM

Or using MONTH function..

**frogboy** · 11-09-2012, 10:49 AM

Thanks for the replies. Just another addition to this:
As well as highlighting the month column in respect to the current date as described above I woud also like to highlight any rows that intersect the month column providing there is some text in the cell. For example I would like to highlight the November column based on todays date (which has been done above) and then have horizontal range of cells highlighting if the cell in the Novemebr column contains any text. I hope this is understandable. cheers