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

A

Adamb

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
 
F

Frank Kabel

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

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.)
 
Top