Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |