I have some text cells that have some special charters in them, “---“, I need to have these cells filled with another color other than the default color. Can any one help me pull this string out and then color the cell?
I am getting an error, "A value used is of the wrong data type". What I need to do is I have a spreadsheet that has numerical values. Some cells have alph with the numbers. I need to find those cells and fill those cells with a different color.