change cell fill color when text is entered

G

Guest

Does anyone know of a way (macro) to have the color of a cell change to "no
fill" automatically when text is entered? TIA-
 
J

J.E. McGimpsey

Any reason not to use Conditional Formatting instead?

CF: Formula is =ISTEXT(A1)
Format: ==>Patterns/No color
 
Top