C
Cobra2140
I have a spreadsheet to track my sections training.
One column shows the date they had the training, the adjacent column shows
when that training is due based on completed date plus certain days.
Conditional formatting is set up to change the cell color based on overdue,
30-60 days due, 60 to X days due, where X is a separate referenced cell I can
type any number in.
When I entered that number in 2003, the conditional formatted cells will
change color to reflect the due training. In 2007, they will not unless you
either re-open the spreadsheet, or zoom in/out of the spreadsheet.
Any suggestions?
One column shows the date they had the training, the adjacent column shows
when that training is due based on completed date plus certain days.
Conditional formatting is set up to change the cell color based on overdue,
30-60 days due, 60 to X days due, where X is a separate referenced cell I can
type any number in.
When I entered that number in 2003, the conditional formatted cells will
change color to reflect the due training. In 2007, they will not unless you
either re-open the spreadsheet, or zoom in/out of the spreadsheet.
Any suggestions?