Conditional formatting

[Doug Day]

I need to have cells with 4 formatting conditions. Excel allows up to 3.
Does someone have a way to accomplish this, maybe with a macro or Visual
Basic?
I know formulas can be used in conditional formatting, as in
=max (A1:a32)=A1
I see in a Excel Macro reference there are Format Macros but am not sure if
I can use them in a conditional Format.
Any suggestions will be appreciated.
Doug

[Bob Phillips]

Set all cells to a default format, and then you have 4, 1 default, and 3
conditional.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Doug Day" <[email protected]> wrote in message
news:C0A72A80.283EF%[email protected]...
> I need to have cells with 4 formatting conditions. Excel allows up to 3.
> Does someone have a way to accomplish this, maybe with a macro or Visual
> Basic?
> I know formulas can be used in conditional formatting, as in
> =max (A1:a32)=A1
> I see in a Excel Macro reference there are Format Macros but am not sure
if
> I can use them in a conditional Format.
> Any suggestions will be appreciated.
> Doug
>