Conditional formatting: adding extra conditions

P

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
 
N

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)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top