CF for split numbers

[Newbienew]

Great day Experts,

I am looking for a CF formula that will check if one side of a number is greater than the other side. The formula I was attempting to use was IF(left(A2,1)>right(A2,1),true,"") to turn red and IF(left(A2,1)<=right(A2,1),true,"") to turn green. The issue I ran into is that this formula only works 1 character. Is there a better way to achieve what I am trying to do?

Book1
	A	B	C
2	7/4	8/13	5/9
Sheet1

 

[6StringJazzer]

When you are writing formulas for CF you don't need to explicitly return TRUE. Write a Boolean condition that evaluates to TRUE or FALSE.

I would first color all cells green as a default. Then you only need a single CF rule to turn some red:

=LEFT(A1,FIND("/",A1)-1)>MID(A1,FIND("/",A1)+1,99)

$scratch.xlsm
	A	B	C
1	7/4	8/13	5/9
split numbers

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C1	Expression	=LEFT(A1,FIND("/",A1)-1)>MID(A1,FIND("/",A1)+1,99)	text	NO

[Later versions of Excel can use TEXTBEFORE and TEXTAFTER instead of LEFT, MID, and FIND]

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C
1
2	7/4	8/13	5/9
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C2	Expression	=LEFT(A2,FIND("/",A2)-1)+0>REPLACE(A2,1,FIND("/",A2),"")+0	text	NO

 

[Newbienew]

@6StringJazzer, I took your advice on making the area green. Thank you
@Fluff Thank you for the second option, gratefully appreciate it.

In the event that I wanted to have the reverse version of this formula where it turns green due to the right side of the / is greater than the left. How would I change the formula for it wo work?
Thank you in advance.

 

[Fluff]

Just change the > to <

 

[Phuoc]

One way:

Book1
	A	B	C
1
2	7/4	8/13	5/9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C2	Expression	=--("0 "&A2)>1	text	NO

 

[Scott Huish]

One way:

Book1
	A	B	C
1
2	7/4	8/13	5/9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C2	Expression	=--("0 "&A2)>1	text	NO

Also:
=INT("0 "&A2)