How to compare two numbers in one cell in Google Sheets?

Question

Google Sheets

Good afternoon, I'm looking for information about comparing numbers or numbers in one cell and I can't find it anywhere. Maybe I'm not looking correctly. For example, the cell contains the numbers 4:6, so that the function understands that 4<6 means that the adjacent cell is highlighted in green or another color. Thank you.

Answer 1

Use REGEXEXTRACT ( text ; regular expression ) to extract chunks of text so you can compare later, e.g. if the first is less than the second
To highlight an adjacent cell, you can use Format - Conditional Formatting

Answer 2

If it's a string, then you need to use string functions in the conditional formatting formula to pull those numbers out of the cell, and then you can compare them.