IF statements
 

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.

IF statements
 

Select F1 and FormatCFFormula is:

=A1=1234

Or =A11234


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 12:14:02 -0700, MED
wrote:

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.