Format a DIFFERENT cell

C

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

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
 
Top