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

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

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

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

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

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