Count down to Words / Text

  • Thread starter Thread starter Champ
  • Start date Start date
C

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
 
Try this.......

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

Vaya con Dios,
Chuck, CABGx3
 
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")))
 
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).
 
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
 
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
 
Back
Top