Hi

Works fine for me in XL2007
C1 = Team
CF =COUNT(C2:C21=11) Fill Orange
C2:C21
CF Cell Value=1 Fill Light Red

As soon as I put a 1 in the 11th cell within range C2:C21, C1 turns
orange.

--
Regards

Roger Govier


wrote in message
ups.com...
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