Make conditional formatting Macro dependent on cell number format

Hi,

My learning curve in vba continues. This macro shades cells if they are higher in value that left adjacent.

I would like this macro to only apply to cells with number format: custom ##,##0;-##,##0 and ignore cells displaying currency: custom: \€#,##0;-\€#,##0. Please note these cell formats derive from a old macro I did not develop and dare not touch.

Any suggestions for a solution are greatly appreciated.

Please Login or Register  to view this content.

You can just add that in as an additional condition:

Please Login or Register  to view this content.