In B1 type the formula

=IF(A10,"yes","")

In this case I chose the word "Yes" as the word of your choice.

"FC" wrote:

I'm trying to get a formula ( 1st choice) or conditional formating that will
do this :
When writing a number or text in A1 for example, another word of my choice
will fill B1. No macros unless there is no other choice please. Thanks.