Ended up with a new problem. I maintained the verification/alert idea of
the Conditional Formatting where the field value is checked against a
reference list (with data pulled from a database).

However, due to the new layout of the worksheet it's simply impractical
to have the reference list on the same worksheet. So I thought of moving
it to another worksheet in the same workbook. But I discovered at the
end that Conditional Formatting only works with one worksheet, not with
two (or more).

So, how to make this work? Thinking of macros here taking the range of
another worksheet, but so far no luck with that either. Intersect can
take the whole used part of a column from another worksheet as range
right?


--
Lava
------------------------------------------------------------------------
Lava's Profile: http://www.excelforum.com/member.php...o&userid=27793
View this thread: http://www.excelforum.com/showthread...hreadid=475394