G Guest Dec 27, 2003 #1 Does anyone know of a way (macro) to have the color of a cell change to "no fill" automatically when text is entered? TIA-
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 Dec 27, 2003 #2 Any reason not to use Conditional Formatting instead? CF: Formula is =ISTEXT(A1) Format: ==>Patterns/No color
Any reason not to use Conditional Formatting instead? CF: Formula is =ISTEXT(A1) Format: ==>Patterns/No color
