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