View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Tom Ogilvy
 
Posts: n/a
Default auto color fill cells

Format=Conditional format

Cell Value is Not Equal To ""

--
Regards,
Tom Ogilvy


"Chopper" wrote in message
...
how do I have cells auto background fill to a certain color when I enter
texted into them?...... I don't want to have to do it one by one, nor do I
want the whole colum to be that color, just the cells when I enter text

into
them, is that possible?