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