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