| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format Question
10
X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format Question
Use a formula that anchors the row
=K$3200 =K$3=150 =K$30 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... 10 X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format Question
Hi Bob Unless I did it wrong it never worked right. Cells S3,T3,U3,are used
to show the score to end the game. The score is centered .Cell S3 has the formula to get the score when i select s3,t3,u3,and apply condition only s3 changes like i want still using your formula I put =S$3200 green =S$3=150 Yellow and S$30 Red but only S3 changed color. Thanks Karl "Bob Phillips" wrote: Use a formula that anchors the row =K$3200 =K$3=150 =K$30 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... 10 X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format Question
Karl,
I read it as multi-row, I now see you have it multi-column, so change the anchor =$U3200 =$U3=150 =$U30 In this I assume the total score is in U3, I didn't really understand what you meant by score is centred, so change it if I am wrong. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... Hi Bob Unless I did it wrong it never worked right. Cells S3,T3,U3,are used to show the score to end the game. The score is centered .Cell S3 has the formula to get the score when i select s3,t3,u3,and apply condition only s3 changes like i want still using your formula I put =S$3200 green =S$3=150 Yellow and S$30 Red but only S3 changed color. Thanks Karl "Bob Phillips" wrote: Use a formula that anchors the row =K$3200 =K$3=150 =K$30 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... 10 X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format Question
Hi Bob I got it to work the score was centered between s3,t3,u3 in those 3
cells but the formula was only in s3 t3 and u3 were basically blank. The 3 cells look like this on the sheet.The formula is only in s3 though. Hope this makes sense. Thanks Karl 10 x x 7 148 "Bob Phillips" wrote: Karl, I read it as multi-row, I now see you have it multi-column, so change the anchor =$U3200 =$U3=150 =$U30 In this I assume the total score is in U3, I didn't really understand what you meant by score is centred, so change it if I am wrong. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... Hi Bob Unless I did it wrong it never worked right. Cells S3,T3,U3,are used to show the score to end the game. The score is centered .Cell S3 has the formula to get the score when i select s3,t3,u3,and apply condition only s3 changes like i want still using your formula I put =S$3200 green =S$3=150 Yellow and S$30 Red but only S3 changed color. Thanks Karl "Bob Phillips" wrote: Use a formula that anchors the row =K$3200 =K$3=150 =K$30 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... 10 X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format Question
I see, it is probably a merged cell. I deplore merged cells, so much bother
<bg -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... Hi Bob I got it to work the score was centered between s3,t3,u3 in those 3 cells but the formula was only in s3 t3 and u3 were basically blank. The 3 cells look like this on the sheet.The formula is only in s3 though. Hope this makes sense. Thanks Karl 10 x x 7 148 "Bob Phillips" wrote: Karl, I read it as multi-row, I now see you have it multi-column, so change the anchor =$U3200 =$U3=150 =$U30 In this I assume the total score is in U3, I didn't really understand what you meant by score is centred, so change it if I am wrong. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... Hi Bob Unless I did it wrong it never worked right. Cells S3,T3,U3,are used to show the score to end the game. The score is centered .Cell S3 has the formula to get the score when i select s3,t3,u3,and apply condition only s3 changes like i want still using your formula I put =S$3200 green =S$3=150 Yellow and S$30 Red but only S3 changed color. Thanks Karl "Bob Phillips" wrote: Use a formula that anchors the row =K$3200 =K$3=150 =K$30 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Karl" wrote in message ... 10 X X X 190 This basically represents a 10th frame in Bowling.The formula to get the bowling score is in the cell where the 190 is represented here. When I center the score in the 3 cells and conditional color it the other 2 cells will not show the same color as the scoring cell. I want all 3 cells to show green over 200 yellow for 150-199 and red for anything below 150.When i put conditional format the scoring cell turns yellow as i want but the other cells turn red. Hope this makes sense. Thanks Karl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format won't copy | Excel Discussion (Misc queries) | |||
| Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
| Copying a conditional format | Excel Worksheet Functions | |||
Hybrid Mode
