Prev: Multiple IF function
Next: vlookup, concatenated named range
From: Goyo on 13 Mar 2010 12:32
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?
From: Gord Dibben on 13 Mar 2010 13:06
A1 cell formula =IF(B1="","",B1)

A1 Conditional Formatting>Formula: =A1=""


Gord Dibben MS Excel MVP

On Sat, 13 Mar 2010 09:32:01 -0800, Goyo <Goyo(a)discussions.microsoft.com>
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?

 | 
Pages: 1
Prev: Multiple IF function
Next: vlookup, concatenated named range