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