Count down to Words / Text

[Champ]

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

 

[clr]

Try this.......

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

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

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(bb10<0,"Too many",if(bb10=0,"Full",if(bb10=10,"ALL",bb10 & " to go")))

 

[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]

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

 

[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