Hi Richard
Rather than try and re-create the code you have already, post it here and
someone can then amend to suit your needs

--
Cheers
Nigel



"Dickie Worton" wrote in message
...
Hi,

I might be asking for too much here, but what I am trying to do is to set
up
a spreadsheet which contains conditional formatting for more than 3
conditions (not too hard). However, I also want to have each condition
reference pairs of cells elsewhere in the worksheet that will define the
two
parameters between which the input value will need to fall in order to
satisfy the condition criteria (does that make sense?)

I have just about got to grips with the conditional formatting for more
than
3 conditions, however it is referencing these cells in the 'Case' part of
the
VBA code that has me beaten. The reason that I don't want to simply put
the
parameters into the VBA code is that they are subject to change on an
annual
basis. As such, it would be preferable to simply update the pairs of
values
the sheet that the condition makes reference to, in order to avoid having
to
amend vast numbers of conditions in the VBA code on an annual basis.

I gather that Excel 2007 no longer has the restriction of 3 conditional
formats, however the organisation where I work are unlikely to be moving
to
this anytime soon, hence my desire to find an answer to this problem. It
should also mean that anyone could update the sheet annually for parameter
changes, rather than needing to have an aptitude for Excel programming to
achieve this.

I'm hoping rather than expecting, but if anyone has any ideas, they will
be
most gratefully received.

Thanks,

Richard