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, certain
cells 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 that I am done. This worked fine in 2003/XP/2000.
The earlier mentioned Yellow format is instant, working as before


Has anyone seen this, and offer a fix/workround?
Thanks
Neil