How do I highlight a cell?
 

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.

How do I highlight a cell?
 

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.

How do I highlight a cell?
 

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