'Trying to Highlight the Value From Conditional Formatting

I am trying to highlight the Column J using Conditional Formatting in case of first value before / >139 OR Last value after / >89 then highlight. I have tried but its not working. your help will be appreciated.

=OR(IF(TRIM(LEFT(J3,FIND("/",J3)-1))>139),IF(RIGHT(J3,FIND("/",J3)-2)>89))

Sheetlink

regexgoogle-sheetsgoogle-sheets-formulaextractconditional-formatting


Solution 1:[1]

try:

=(REGEXEXTRACT(J1, "^\d+")*1>139)+(REGEXEXTRACT(J1, "\d+$")*1>89)

enter image description here

Solution 2:[2]

Just for interest, you can get your find/right/left formula to work as well but you have to use -- (or value or *1 like @player0) to convert the substring into a number:

=OR(--LEFT(J3,FIND("/",J3)-1)>139,--RIGHT(J3,len(J3)-FIND("/",J3))>89)

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0
Solution 2

Related Questions