N
neil40
Hi,
I've had this oddity in both Beta and release versions of 2007 Excel.
On a sheet for recording sports results for a team of players, in
certain cells that should turn to yellow background if I add a number 1
to the cell
On the same sheet, I have a conditional format for the column headers,
such that the cell should change colour if the result of a sum is 11
(IE I have added the number 1 to 11 players boxes) - this is just a
visual reminder to tell me that my selection is complete, as the sheet
is quite long
The cell DOES change colour BUT only if I navigate to another sheet and
come back to it - and thats hardly the point as I am trying to get the
visual reminder I am done. This worked fine in 2003/XP/2000.
The earlier mentioned Yellow format is instant.
Has anyone seen this, and offer a fix/workround?
Thanks
Neil
I've had this oddity in both Beta and release versions of 2007 Excel.
On a sheet for recording sports results for a team of players, in
certain cells that should turn to yellow background if I add a number 1
to the cell
On the same sheet, I have a conditional format for the column headers,
such that the cell should change colour if the result of a sum is 11
(IE I have added the number 1 to 11 players boxes) - this is just a
visual reminder to tell me that my selection is complete, as the sheet
is quite long
The cell DOES change colour BUT only if I navigate to another sheet and
come back to it - and thats hardly the point as I am trying to get the
visual reminder I am done. This worked fine in 2003/XP/2000.
The earlier mentioned Yellow format is instant.
Has anyone seen this, and offer a fix/workround?
Thanks
Neil