Format a DIFFERENT cell
 

I'd like to set something up so if cell F1 meets my requirements (say, 120),
cell A1 turns color. Is this possible (without complicated programming,
please)?

Format a DIFFERENT cell
 

Select A1 and FormatConditional FormattingFormula is:

=$F$1120

Format to a nice color and OK your way out.

Note the $ signs can be removed or changed around to allow copying this to other
cells.


Gord Dibben MS Excel MVP


On Thu, 19 Jun 2008 14:51:14 -0700, ClaireView
wrote:

I'd like to set something up so if cell F1 meets my requirements (say, 120),
cell A1 turns color. Is this possible (without complicated programming,
please)?