Coloring of cell when entering data
Select last name column..........B for example.
FormatConditional FormattingFormula is:
=ISTEXT($B1)
Format to a color and OK your way out.
Gord Dibben MS Excel MVP
On Mon, 6 Aug 2007 11:32:12 -0700, Qisme615
wrote:
I have to input client's last and first names ( 2 different columns). I want
to be able to type the last name and each cell in the last name column will
change color automatically when I type. I know how to color the whole column
but not this method. A coworker was able to do it but she left and I can't
ask her. Hope I made sense, if someone could guide me I would appreciate it.
Thank you.
|