Hi,

Yes, you can name a range and then use conditional formatting across
worksheets. Could be very specific about the example.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Chriswilsonuk" wrote in message
...
I have tried you example and it worked using a named cell.

Is there a way to get this to work on a range of cells or do I have to
name
each individual cell. This could get very compolicated very fast with the
sheet I am using.

Thanks

Chris