Thanks for the reply Hutch,

Can this work with multiple ones, like if D5 said blue it would change D6 to
yes if it said Red then it would change D6 to No etc

Thanks again

"Tom Hutchins" wrote:

Put this in D6:

=IF(D5="blue","yes","no")

"no" in this example is what D6 will show if D5 does NOT contain "blue"

Hope this helps,

Hutch

"Tom Jacques" wrote:

i want to have a cell automatically fill its self in when another cell says a
certain thing.

eg - if i type "blue" into D5 i want D6 to automatically change to "yes"

Is this possible

Thanks