A VB solution would be very satisfactory - do you have some code?

Roger



"Rick Rothstein" wrote:

If you are not using XL2007 (and your comment about 3 condition seems to
indicate you are not), then you will need to use VB event code to handle
your 6 conditions. Is a VB solution acceptable?

--
Rick (MVP - Excel)


"Roger on Excel" wrote in message
...
Hi,

Conditional formatting allows for 3 conditions.

I require 6 for the following ranges of data in a field spannin A1 to G50

0-0.1 pale yellow
0.1-0.25 yellow
0.25-1.0 pale orange
1.0-1.5 orange
1.5-2.0 pale red
2.0 red

I guess an IF, THEN statement might work?

Can anyone help?

Thanks,

Roger