Excel 2003 6 colour ConditionalFormatting

[lifeboat01]

Hi

Im looking at 6 colour formatting based on the following: Repair, Refit, Relief, On service, Off Service,Yard,but Excel 2003 only has 3 conditions. This would run in cells B3:H20. I know it's VBA but cant quite figure it out.

Any help is appreciated

Colin

 

[xlbo]

This is about as comprehensive as it gets for conditional formatting prior to 2007 thread68-223068

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question