Problem trying to identify if cell is greater than

[sharky12345]

I have a cell which is formatted as number with 2 decimal places, (current value is 24:53).

I have another cell which is formulated as general and has a current value of 30.

I'm trying to identify if the first cell is greater than the second one, in the example above the answer is false, but no matter what I try the answer I get with conditional formatting is wrong. I assume it's the way the cells are formatted but I need the current formatting to remain so can someone explain why it won't work?

I should add that ideally I'm trying to identify the result by VBA if possible.

 

[Dave Patton]

T202011b.xlsm
	B	C	D
2	50	30	TRUE
3	24.53	30	FALSE
2d

Cell Formulas
Range	Formula
D2:D3	D2	=B2>C2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	Expression	=B2>C2	text	NO
B3	Expression	=C3>B3	text	NO

 

[maabadi]

Test this (for cell C1 & D1):

Sub test2()
If Range("C1").Value > Range("D1").Value Then
Cells(1, 3).Interior.Color = RGB(255, 0, 0)
Cells(1, 3).Borders.Color = RGB(192, 192, 192)
Cells(1, 4).Interior.Color = RGB(255, 255, 255)
Cells(1, 4).Borders.Color = RGB(192, 192, 192)
Else
Cells(1, 4).Interior.Color = RGB(255, 0, 0)
Cells(1, 4).Borders.Color = RGB(192, 192, 192)
Cells(1, 3).Interior.Color = RGB(255, 255, 255)
Cells(1, 3).Borders.Color = RGB(192, 192, 192)
End If
End Sub

 

[sharky12345]

Thanks guys!