More than 3 conditional formats in Excel? 1

[EvilTwinOfAtrus]

Hi,

I'm using Excel 97 and was wondering if theres a way of making more than 3 conditional formats which the 'Format -----> Conditional Formatting' provides.

Many Thanks,
Karl

 

[nberryman]

You can have 4 conditions as is, No condition and then the 3 conditions but if you need more then check out

thread68-223068

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[SkipVought]

Karl,

Actually, you have 4 states you can control - the PRE-Formatted state plus 3 in Conditional Formatting.

To control any more that that takes some VBA Programming.



Skip,

http://www.TheOfficeExperts.com

 

[EvilTwinOfAtrus]

Thankyou