"Excelenator" wrote:
Conditional formatting won't allow you to reference another worksheet, ..

True, but using INDIRECT is a way to do so "directly" which is accepted in
CF,
as per earlier response to OP. Another route is to use defined ranges.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---