I have a phone data spreadsheet with 5K cols and 24K rows. I would like to create two macros.

First - to read data in each col and
1. if all of the data (alpha/numeric) is the same fill in the header cell green
2. if there are any blank cells (null) fill in the header yellow
3. if the data is different fill in the cells red

Second - run a macro that would tell me in the col that finds differences in data (#3 above), what percent of the cells are different.

This is above my current talent level so any help would be greatly appreciated.

Jerry