How do I highlight a cell?

[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.

 

[David Hager]

Assign defined names to the cells in other worksheets. You can then use them
in conditional formatting formulas.

 

[Debra Dalgleish]

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)