Hello,

is it possible to use conditional formatting to fill a cell with text?


Ex) if cell a1 contains the word "float", i want conditional formatting to put "fl" in b1


thank you in advance for your help !!!!