Excel 2002 Condition Formatting...cont

[DLC]

Got it to work but will not work when referencing another sheet in the
workbook.

 

[Bob Phillips]

When using a range in another sheet you need to define a name for that range
for CF to work.