| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| I can't see Highlight cell in Find & Replace Cell | Excel Discussion (Misc queries) | |||
| click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
