Macro to Format all cells in column according to value. Macro in Excel2010

I need Macro to Format all cells in column according to value. The cutoffs are >20, between 21 and 50 (>21;<50) and greater than 51 (<51).
I have macro to consolidate cells from multiple files to single workbook. Now I have to 'color code' the value in all cells in column 'B', all as part of one large macro.

Any idea?

try the following code:

Please Login or Register  to view this content.