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

[sales]

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

 

[flummi]

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

 

[Ken Johnson]

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