Jan 05 2021 01:10 AM
Jan 05 2021 01:46 AM
@Jelaamii Play around with custom number formats as demonstrated in the picture below. You enter a number but Excel displays it with the " ms" at the end. But, it's still a number that you can use in conditional formatting.
Jan 05 2021 01:46 AM
If that's always "ms" at the end you may use something like
=REPLACE(I6,LEN(C16)-1,2,"")*1 >= 6
Jan 05 2021 03:03 AM
Jan 05 2021 03:07 AM
Jan 05 2021 03:11 AM
Solution@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.
Jan 05 2021 03:11 AM
Solution@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.