if then question

[mmccra2858]

I have a spreadsheet in one column I have "date closed" on another I have "status".
I would like to write an if then formula to say, if a date is entered in F5 (date closed) then E5 says "Completed"...

[Cutter]

How about

=IF(ISNUMBER(F5),"Completed","")

[mmccra2858]

would the formula be in e5 or f5

[Cutter]

That would be in E5

[mmccra2858]

it works great.
Is ther any way to make the cell gray at the same time?

[Cutter]

Use the Conditional Formatting feature.

[mmccra2858]

Right, thank you

[Cutter]

You're welcome. Happy to help.

[mmccra2858]

Something I didn't consider E5 has information in it, i still need to have information in that cell but when teh date is entered in cell F5 I want it to change to Completed.
How can I do that and maintain information in cell e5?

[Cutter]

What kind of information is there? Formula, keyed entry....?

[mmccra2858]

just keyed entry information. Status of job assignments.

[Cutter]

That will require VBA (Worksheet Change Event). I'm not a VBAer so if you want help with that then someone else will have to provide it for you.

[mmccra2858]

Ok thanks for all your help

[Cutter]

I suppose an alternative could be to set up 2 rules in Conditional Formatting - 1 to turn the cell gray when it contains the word "Completed" and another rule to change it, say red, if there is a date in F and E does not say "Completed". That would serve to alert the user to input "Completed". To make it easier you could have Data Validation to provide a list of entries acceptable for that cell, "Completed" being in the list. Assuming there is a finite list of possible entries.

If you want help with VBA let me know and I'll see if I can get someone to have a look at this thread.