How do I highlight a cell?

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

David Hager

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top