Formatting/Formulas
 

I want to be able to have my cells highlighted yellow until I place
information into them. I have done it before but can't rember what function
to use.

Formatting/Formulas
 

Formatconditional formattingformula is

=A2=""

click format button and pattern, select yellow and click OK twice

replace A2 with the first cell of a selected range for instance if you want
this to
happen in C2:C100, select that range and use

=C2=""

with C2 as the active cell


--


Regards,


Peo Sjoblom


"aloken" wrote in message
...
I want to be able to have my cells highlighted yellow until I place
information into them. I have done it before but can't rember what
function
to use.

Formatting/Formulas
 

Select the cells to format and click FORMAT in the menu and select
CONDITIONAL FORMATTING.

In the CONDITIONAL FORMATTING dialog box, change CONDITION 1 to FORMULA IS
and in the text box to the right enter the following formula, changing the A1
in the example to the starting cell of your selected range:

=ISBLANK(A1)

Or if you want to treat any errant spacebar entry as a blank cell

=LEN(TRIM(A1))=0

Click the FORMAT command button, select the PATTERNS tab and select the
color you want and click OK 2 times to exit.


--
Kevin Backmann


"aloken" wrote:

I want to be able to have my cells highlighted yellow until I place
information into them. I have done it before but can't rember what function
to use.