Conditional formatting based on formula cell

[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

 

[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

 

[Andy Roberts]

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

 

[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

 

[Andy Roberts]

Thanks Claus, spot on again

Hi Andy,

Am Sun, 16 Jun 2013 15:05:28 +0100 schrieb Andy Roberts:


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