Conditional formatting based on formula cell


A

Andy Roberts

I have a cell which returns a value from elsewhere (its a vlookup formula)
with an iserror function attached so that if there is no result the cell
appears blank (but its not as it contains the formula). next to the cell I
have a cell with conditional formatting which changes bases on whether the
cell is "blank" or not but i can't use "isblank" as the cell contains the
formula. How do I get around this? The cell result can be a mixture of
alpha and numeric characters and can be totally unique so i can't base the
conditional formatting on the cell value.

--
Regards

Andy
Win XP Pro
Office 2010
 
Ad

Advertisements

C

Claus Busch

Hi Andy,

Am Sun, 16 Jun 2013 11:34:52 +0100 schrieb Andy Roberts:
I have a cell which returns a value from elsewhere (its a vlookup formula)
with an iserror function attached so that if there is no result the cell
appears blank (but its not as it contains the formula). next to the cell I
have a cell with conditional formatting which changes bases on whether the
cell is "blank" or not but i can't use "isblank" as the cell contains the
formula. How do I get around this? The cell result can be a mixture of
alpha and numeric characters and can be totally unique so i can't base the
conditional formatting on the cell value.
for the formula in A5 try for the other cell:
=A5=""


Regards
Claus Busch
 
A

Andy Roberts

Thanks for your suggestion Claus but I'm not sure i follow what you mean?
 
C

Claus Busch

Hi Andy,

Am Sun, 16 Jun 2013 15:05:28 +0100 schrieb Andy Roberts:
Thanks for your suggestion Claus but I'm not sure i follow what you mean?
select the cell to be formatted => Conditional Formatting => New Rule =>
Use Formula...... and put in the formula:
=A5=""
Replace A5 with the cell address of your cell with vlookup


Regards
Claus Busch
 
A

AASHISH

I need formula such as if I insert a text in cell, the whole sentence reflects. I mean : Mr.......have been sanctioned HL.
In this cell I need to add only name & whole sentence comes as default with the name inserted. Plz suggest.
 
A

AASHISH

I need formula such as if I insert a text in cell, the whole sentence reflects. I mean : Mr.......have been sanctioned HL.
In this cell I need to add only name & whole sentence comes as default with the name inserted. Plz suggest.
 
Ad

Advertisements

A

AASHISH

I need formula such as if I insert a text in cell, the whole sentence reflects. I mean : Mr.......have been sanctioned HL.
In this cell I need to add only name & whole sentence comes as default with the name inserted. Plz suggest.
 

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


Top