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