How do I highlight a cell?

  • Thread starter Thread starter MNJ
  • Start date Start date
M

MNJ

How do I highlight a cell? I want to highlight a cell in
sheet A if the value in cell that cell is not between two
cells in sheet B. I've tried using the conditional
formatting feature but it says that I can not reference
cells in other worksheets.

For example, sheetA!A1 is 10 and sheetB!A1 is 1 and sheetB!
A2 is 5. I want cell sheetA!A1 to be highlighted yellow
because 10 is not between 1 and 5. Thank you for any help.
 
Assign defined names to the cells in other worksheets. You can then use them
in conditional formatting formulas.
 
If you name the cells on Sheet2, you can refer to them in the
Conditional Formatting formula. There are instructions here for naming
cells:

http://www.contextures.com/xlNames01.html

In the Conditional Formatting for Sheet1!A1, choose Formula Is, and
enter a formula that refers to the named ranges: =OR(A1<Low,A1>High)
 
Back
Top