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.

--
David Hager
Excel MVP

"MNJ" wrote in message
...
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.

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,A1High)

MNJ wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html