formatting cells

  • Thread starter Thread starter katie
  • Start date Start date
K

katie

is there a formula to put the work "active" in all cells
in a column automatically unless a date is entered to
indicate inactive? Thank you

Katherine
 
you could test for a numeric input and maybe even put validation on the
cells
then use something like

=IF(ISNUMBER(A1),"","Active")

where in this case A1 would hold the date/blank
copy down along

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi Katie.........

I would just type the word "Active" in the cell at the top of the column and
then copy it all the way down.........then whenever you enter a date in that
cell, it just overwrites the word "Active", and only the date
shows..........no formula needed.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top