S
sueshe
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!!!
(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!!!