Formatting conditional columns with macros

I suggest RECORD macro following these steps

1.select any cell
2.click record macro and choose macro name
3.shade the selected cell using format-cells-pattern etc
3.end recording
now see this macro it will give you idea how to modify the macro

my version is excel 2002."xlsolid16" is not a variable in my version. The recording macro will help you

my recoreded macro in my version gives

Please Login or Register  to view this content.