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

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" wrote in message
...
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