sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
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.
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.
Last edited: