You could apply conditional formatting to your range. For
example, assume you're going to enter data into A1:F25.
1. Select A1:F25
2. Go to Format Conditional Formatting
3. Under Condition 1 select Formula Is and put:
=LEN(INDIRECT("rc",0))0
4. Press the Format radio button and format as desired.
HTH
Jason
Atlanta, GA
-----Original Message-----
If I have a cell(s) in excel that when I type data in it
I would like for the
cell to become highlighted. Is there a way that I can
make this automatic or
must I highlight each cell(s) individual.
.
|