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.
If that's always "ms" at the end you may use something like
=REPLACE(I6,LEN(C16)-1,2,"")*1 >= 6- SergeiBaklan thanks for your reply. Do you mind breaking down how does this formula work? I have tried using it but it only works if i did not input the value with "ms". For example, it stays the same color when i input "6ms" into the cell but it does change to red when i input only "6"
If you enter just numbers better to use Riny_van_Eekelen suggestion
