First of all I'd like the macro to highligh the entire sheet (I can do that part) and edit any cell that has the following "type" entry: "<10000", "<60000" etc. I would like these entries changed to "<1,000" and "<60,000" respectfully. I generated an excel formula to generate the desired change...