Count down to Words / Text

Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ

Try this.......

=IF(SUM(10-BB10)=10,"ALL",IF(SUM(10-BB10)=0,"FULL",""))

Vaya con Dios,
Chuck, CABGx3





"Champ" wrote in message
...
Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ

First, the formula in BB8 could be: =10-bb10

The =sum() doesn't help.

Then you could use this instead:
=if(bb10=0,"Full",if(bb10=10,"ALL",bb10 & " to go"))

In fact, I'd check to see if there were too many...
=if(bb100,"Too many",if(bb10=0,"Full",if(bb10=10,"ALL",bb10 & " to go")))

Champ wrote:

Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ

--

Dave Peterson

ps. Then you can use Format|conditional formatting to show the nice color
(value is FULL).

In xl2003, you only get 3 conditional formats (plus the normal one).

Champ wrote:

Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ

--

Dave Peterson

CLR,

Thank you a bunch - yes that does work.
Is there a way to make FULL turn Red?

In addition to that, is there a way when the number is "0" can that previous
formula also incorporate the same for empty and make that turn EMPTY turn
green?

Thanks again,
Champ


"clr" wrote:

Try this.......

=IF(SUM(10-BB10)=10,"ALL",IF(SUM(10-BB10)=0,"FULL",""))

Vaya con Dios,
Chuck, CABGx3





"Champ" wrote in message
...
Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ




.

Dave,

That worked perfectly and thanks for the heads up on the first part about
sum doesn't help or hurt.

You helped make this sheet sing - Thank You and Happy New Year,
Champ

"Dave Peterson" wrote:

ps. Then you can use Format|conditional formatting to show the nice color
(value is FULL).

In xl2003, you only get 3 conditional formats (plus the normal one).

Champ wrote:

Hello,

Is there a way to have a cell that is counting down from "10" and when it
hits "0" spell the word FULL and in Red?

example:

cell BB10 has a formula in it: =COUNTA(H10:AV10)
cell BB8 has a formula in it: =SUM(10-BB10)

NOTE: there are only 10 entities max in cells H10 through AV10 and that is
why I subtract BB10 from 10.

I want cell BB8 to reflect the word ALL when there is 10 and FULL when the
countdown hits "0"

Can this be done?

Thanks,
Champ

--

Dave Peterson
.