VBA for Conditional Formatting - apply a colour based on conditions in each column.

Dear Friends,

I have a table - named "mytable". I need to apply conditional formatting on TWO occasions through VBA:

1) Apply a color (green) in entire column - if there is no value or if there not more than ZERO value.
2) Apply a color (yellow) in entire column - if any formula is applied.

Kindly help me...

see saple file attached also containing the macro "testg"
run the macro once and again another time

Please Login or Register  to view this content.

Dear Friend,

The concept is achieved. However, the vba applies to each row, that too to entire row (i.e. to all values).

I need to make conditional formatting for each column, as mentioned in the sample file.

Request kind help.

acsishere.

Any help would be highly appreciated.