Conditional Formating

[DeWayne24]

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?

 

[ADAMC]

Hi welcome to the board!

Do the cells just contain --- or do they have text around them like abc---123?

 

[DeWayne24]

An example of the cell contant is "29 ----"

 

[Legacy 51064]

conditional format

formula equals =FIND("---",$A1)>0


then you can format the cell as you want.

 

[ADAMC]

The formula above will work but do you need the --- part?

If not Ctrl + H
Find what: **---
Replace with: **

 

[DeWayne24]

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.

 

[ADAMC]

Can you not just delete them as per my my previous reply?

 

[DeWayne24]

I don't need to delete them, just change the fill color of the cell.