Conditional formatting based on formula cell

Giganews Newsgroups
Subject: Conditional formatting based on formula cell
Posted by:  Andy Roberts (an…@blue-bean.co.uk)
Date: Sun, 16 Jun 2013

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

Replies