Hello,

I am working on a macro and I do know how to go about it. I am just getting
started with macro's.
I have an excel sheet that is laid out as a heiarchy chart.

Example:

A B C D

Bob
Gym
13 Years
Senior

I would like to highlight the rows that contain data in COL A one Color, The
rows that contain data in COL B another color, etc.

How can this be coded?