Forum Discussion
Solved
Using conditional formatting to change color of cells depending on its value with text in a cell
I am trying to change the color of a cell according to its value but there are text combined with it which makes it difficult. For example, instead of changing the cell to yellow when its in between 3...
Jelaamii The " ms" part is just a format. It's not part of the cell value. Have a look at the attached file, to see what I mean.
Riny_van_Eekelen thanks for replying. I have tried your suggestion but having this error
Jelaamii The " ms" part is just a format. It's not part of the cell value. Have a look at the attached file, to see what I mean.