Hi there
I was wondering if there was a way to highlight all cells on a worksheet containing a text string (lets say"A"). I want to be able to do this so I can select all applicable cells, and then color them a certain way, and then look for the next text string (lets say "B") and color it a different way.
I would like to be able to do this in one step rather than having to loop through all cells on the worksheet (until the last cell used). I know you can use something like Selection.SpecialCells which will highlight all cells containing constants, but I want to take it a step further and specify the constant that I want it to highlight.
Any help would be greatly appreciated.
I was wondering if there was a way to highlight all cells on a worksheet containing a text string (lets say"A"). I want to be able to do this so I can select all applicable cells, and then color them a certain way, and then look for the next text string (lets say "B") and color it a different way.
I would like to be able to do this in one step rather than having to loop through all cells on the worksheet (until the last cell used). I know you can use something like Selection.SpecialCells which will highlight all cells containing constants, but I want to take it a step further and specify the constant that I want it to highlight.
Any help would be greatly appreciated.