| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight cells
I am trying to highlight a cell if it is empty. However, the cell in
question is pulling data from another page in the worksheet, so the cell is not empty because it contains the address of the referenced cell. I have tried conditional formating and "IF" and couldn't get any of them to work. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlight cells
A1 cell formula =IF(B1="","",B1)
A1 Conditional FormattingFormula: =A1="" Gord Dibben MS Excel MVP On Sat, 13 Mar 2010 09:32:01 -0800, Goyo wrote: I am trying to highlight a cell if it is empty. However, the cell in question is pulling data from another page in the worksheet, so the cell is not empty because it contains the address of the referenced cell. I have tried conditional formating and "IF" and couldn't get any of them to work. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight cells | Excel Discussion (Misc queries) | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Highlight cells in a row with a given value | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| Highlight cells | Excel Worksheet Functions | |||
Linear Mode
