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
|