IF statements

[MED]

I want to use an IF statement to look at one cell in the spreadsheet and if
TRUE then highlight another cell. I have used conditional formatting for
highlighting the cell in which I am evaluating but cannot figure out how to
highlight another cell if the first cell equals a specific value or TRUE.
Also would be happy if the type could just change color. It is a very wide
spreadsheet and the intent is to highlight a customers name if it falls
within a value range so at a glance you can see who is on or off target.

 

[Gord Dibben]

Select F1 and Format>CF>Formula is:

=A1=1234

Or =A1>1234


Gord Dibben MS Excel MVP