View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default one cell's value Highlights selected cells....how?

Select the range in question,
from the main menu select format--conditional format,
on the next screen in the 3 boxes select/type: Cell value is, equal to,
1,
click format,
select the formating option(s),
click ok,
click ok.

Done

Hans