Format a DIFFERENT cell

[ClaireView]

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)?

 

[Gord Dibben]

Select A1 and Format>Conditional Formatting>Formula is:

=$F$1>120

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