Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Conditional formatting based on formula cell

26 views
Skip to first unread message

Andy Roberts

unread,
Jun 16, 2013, 6:34:52 AM6/16/13
to
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

unread,
Jun 16, 2013, 6:43:31 AM6/16/13
to
Hi Andy,
for the formula in A5 try for the other cell:
=A5=""


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Andy Roberts

unread,
Jun 16, 2013, 10:05:28 AM6/16/13
to
Thanks for your suggestion Claus but I'm not sure i follow what you mean?


"Claus Busch" <claus...@t-online.de> wrote in message
news:kpk4sj$q7b$1...@news.albasani.net...

Claus Busch

unread,
Jun 16, 2013, 10:14:11 AM6/16/13
to
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

Andy Roberts

unread,
Jun 17, 2013, 4:37:17 AM6/17/13
to
Thanks Claus, spot on again


"Claus Busch" <claus...@t-online.de> wrote in message
news:kpkh7j$jh0$1...@news.albasani.net...

AASHISH

unread,
Jan 14, 2015, 10:41:48 PM1/14/15
to
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.

AASHISH

unread,
Jan 14, 2015, 10:43:01 PM1/14/15
to

AASHISH

unread,
Jan 14, 2015, 10:43:44 PM1/14/15
to

Mandeep Baluja

unread,
Apr 17, 2015, 2:17:39 PM4/17/15
to
Use the Auto correct option of Excel Go into options setting Excel >option> proofing >auto correct option.

Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
0 new messages