Conditional formatting: adding extra conditions

  • Thread starter Thread starter Pierre
  • Start date Start date
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
 
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.
 
Back
Top