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.