Conditional Formatting on multiple cells

[Karyn]

Can a conditional format be applied, ie display a colour,
to a range of cells based on a conditon in one of the
cells contained in the range?

 

[David McRitchie]

Hi Karyn,

If everything is dependent on a single cell, or
if everything on a row is dependent on a cell in the row there
is no problem. Past that how about an example. See
: http://www.mvps.org/dmcritchie/excel/condfmt.htm