Change a cell with a word

[donjjjordan]

If cell A1 is filled I want A2 to say COMPLETE

[Cutter]

Maybe

=IF(A1="","","Complete")

[day92]

=IF(A1<>"","Complete"," ")

[donjjjordan]

Thanks but i already have a formula in that cell can it be done with conditional formatting?

[Cutter]

You want the cell to say "Complete" and still have a formula?
What is the formula doing? Do you want the cell to say "Complete" when A1 contains something but something else when the formula triggers?

[martindwilson]

as you have excel 2007
you can use conditional formatting
use the use a formula option
put =a1<>""
choose format pick the number tab
choose custom
set custom as "complete" including quotes

[donjjjordan]

attached is what i am trying to do

[donjjjordan]

Thank you Martin

[martindwilson]

yep do what i last posted