Starting in top left of table (assumed to be B2)
Format-conditional format, Formula is
=MONTH(B$1)+1=MONTH($I$2)
Set your format to bold font, blue.

Copy formatting to other cells. Will change all rows of appropriate column.

Note that your headers/dates MUST be entered as dates, as you described, and
not just the words "Jan", "Feb", etc.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"sueshe" wrote:

I have an Excel spreadsheet set up as follows:
(dates formatted as Mmm)
Jan Feb Mar Apr etc......
Insurance 1 17 11 4 9
Insurance 2 1 2 1 0
Insurance 3 15 21 27 20 etc...

I have =today() in cell I2. I enter the numbers for the
previous month, for instance, I just entered April's
numbers. I need them to show as bold, blue for the
previous month, so, since I'm putting in April's numbers,
and we are in May, then that column should show bold
blue. Next month when I'm putting in May's numbers,
April should go back to non bold, black, and May's should
be blue/bold.

Hoping someone can help me with this. I posted this a while
back, but never could get it to work. Thanks for any help you
can give me!!!