Conditional formatting

[DrD]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I add more than 3 conditional formats into cells in a Mac excel 2008 document ?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I add more than 3 conditional formats into cells in a Mac excel 2008
document ?

You can't! But, you may be able to use some intermediate cells to accomplish
the same thing.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I add more than 3 conditional formats into cells in a Mac excel 2008
document ?

As Bob wrote, you can't do that in MacXL. However, if your cell values
are numeric and your formats change font colors, you may be able to use
a combination of CF and Custom Formatting to get up to 6 formats, e.g.:

http://mcgimpsey.com/excel/conditional6.html

 

[Shane Devenshire]

Hi,

Since cells can have a regular color you can add 3 colors on top of that for a total of 4.
I suppose you could write an Apple Script to allow more than the built in limit of 3.