Format Cells with Data in them

[rncd147]

Hello All!

Hopefully an easy one, i just need a little guidance.

I'd like to make a macro that will outline only cells that have something in them. I tried doing this with SpecialCells(xlCellTypeBlanks) but it gets messed up sometimes.

Also, how can i have it do some different formatting on cells that contain certain words? I will populate the list of them myself, just not sure how to code it (GP, SKU etc.)

Thank you all for your help

[jindon]

Something like this

Please Login or Register  to view this content.

[rncd147]

it works! And it is transferable to other workbooks, which is a super plus