one cell's value Highlights selected cells....how?
 

Hi,

I know this is probably simple. But how can I get a range of cells
hghlighted a different colour if one of those cells equals a certain
value.

Any help apprecited.

Col

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

one cell's value Highlights selected cells....how?
 

Hi Col,
If you want the whole range, say A1:A10, to change to the same colour
when any of the cells in that range equal a certain value, say 42, the
meaning of life if my memory serves me correct:-), then I think you
have to use a formula in the conditional formatting of that range of
cells.To do that (for A1:A10 and certain value = 42)...
Select A1:A10
from the main menu select format--conditional format,
on the next screen in the 2 boxes select/Formula Is: type this formula
=NOT(ISERROR(LOOKUP(42,$A$1:$A$10)))
click format,
select the formating option(s),
click ok,
click ok.

Ken Johnson