Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format oddity in Excel 2007
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format oddity in Excel 2007
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format oddity in Excel 2007
Works for me too, just like in 2003.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Roger Govier" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format oddity in Excel 2007
It's not quite so straightforward as doing a count()
Each player has 5 rows Played Sub Yellow Red Goals So I can't just do count over a range of cells What I actually do is: At the foot of the column, I have a calc for every other five cells thus: =(AT3+AT8+AT13....)/11 Then the column header Conditional format is thus: =D$251=1 White (Normal cell colour is light blue!) Hmm, just tried this in the simplest form and it worked instantly. Any ideas? Neil On 25 Jan, 19:19, "Bob Phillips" wrote: Works for me too, just like in 2003. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Roger Govier" wrote in . .. 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 oups.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- Hide quoted text -- Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format oddity in Excel 2007
Well,
I removed the formats, and re-made them, but it still doesn't 'work' (change colour) until I change sheet and back again On 25 Jan, 20:22, " wrote: It's not quite so straightforward as doing a count() Each player has 5 rows Played Sub Yellow Red Goals So I can't just do count over a range of cells What I actually do is: At the foot of the column, I have a calc for every other five cells thus: =(AT3+AT8+AT13....)/11 Then the column header Conditional format is thus: =D$251=1 White (Normal cell colour is light blue!) Hmm, just tried this in the simplest form and it worked instantly. Any ideas? Neil On 25 Jan, 19:19, "Bob Phillips" wrote: Works for me too, just like in 2003. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Roger Govier" wrote in . .. 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 oups.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- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Format in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
color coded cells and conditional format in excel 2003 | Setting up and Configuration of Excel | |||
Where did my Publish to Excel Services go? | Setting up and Configuration of Excel | |||
Excel 2007 beta 2 - Conditional Formatting Suggestion | Excel Discussion (Misc queries) |