ExcelBanter - Highlight cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Highlight cells (https://www.excelbanter.com/excel-worksheet-functions/258829-highlight-cells.html)

Goyo

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?

Gord Dibben

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?

All times are GMT +1. The time now is 10:48 AM.