It makes no difference where the conditions are, you just check anyway.

For instance, if the CF says =E17=12, then you check E12 in the code, not
the cell where the CF is.

Testing for the CF colorindex is remarkably tricky, and not robust. Norman's
suggestion is sounder.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris" wrote in message
...
Checking for the condition(s) in the code is no viable because the
conditions are not of that sell but of other relative cells. Add/Remove
a column or row and the code will be out. There are ways round this with
named ranges but it is getting bigger and uglier to solve what should be
simple.

It is however the only solution so far.

The other way is to read the condition formula and parse it / interprit
it so check for the condition 'again' in code. Any code tips how to
achieve this?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!