conditional formatting text conditions

[mshbhwn98]

Does anyone know if it is possible to apply conditional formatting that displays text based on what you have written. For example

If I type "apples" in cell A1 I want it to display "oranges"

Many thanks

[gringo287]

without knowing what "it" is.. this should get you going at least

[mshbhwn98]

Thanks for your help gringo. Unfortunately that isnt really what I'm after. The point of conditional formatting is that you are not changing the values. I know you can do conditional formatting on a number for example

=A1=1 with condition "apples"
=A1=2 with condition "oranges"

Which would return apples if you type 1 and oranges if you type 2. But the key thing is that the underlying values are still stored as 1 or 2. I wanted to know if it was possible to do this with strings ie
=A1="apples" with condition "oranges"
underlying value would be the string apples but it would display as oranges.

I probably wasnt clear. Thanks for trying anyway