Conditional formatting: adding extra conditions

[Pierre]

Hi,

The Conditional Format in Excel only allows you to enter 3
conditions, therefore ending in 3 different formats
available only.
Is there a way to increase this to 6 or more conditions?

Thanks a lot

Pierre

 

[Norman Harker]

Hi Pierre!

Apart from conditional formats you do have ability to control formats
for negatives, positives, zero and text.

But generally you'd go for VBA to apply more than three formats.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 18th July: Mexico (Day of Mourning
death of Benito Juarez), Spain (Labor Day), Uruguay (Constitution Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.