Highlight cells

G

Goyo

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?
 
G

Gord Dibben

A1 cell formula =IF(B1="","",B1)

A1 Conditional Formatting>Formula: =A1=""


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AppleScript - How do I select a text ? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to colour highlight empty cell 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Change the colour of a cell if another named cell is blank 2
Cumulative formula for word table 0
Shared Link is showing empty notebook 1
conditional formatting update issue 5

Top