View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Day Doug Day is offline
external usenet poster
 
Posts: 1
Default Conditional formatting

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