In Cell D6 put this formula

=IF(D6="blue","yes","")


On Nov 15, 7:13*pm, Tom Jacques <Tom
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