View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.