In Excel how do i automatically replace a number with a phrase if.

[Guest]

I need to set my spread sheet so if a specific number in a colum appears it
is replaced with a a warning in words

 

[Guest]

Hi
not exactly what you're looking for but why not use 'Format - Conditional
Format' to highlighzt such cells

 

[Dave Peterson]

I'd use an adjacent cell:

=if(b1=12345,"Hey, it's a neat number,"")

format it bold/red and it'll get the user's attention right away.

(If it's different from 12345, the cell will look empty.)