Conditional Formatting on Fractions

[Darko_Giac]

Hi all,


I am currently trying to use conditional formatting to highlight a cell in red where the numerator is smaller than the denominator.

One thing to note is that the fractions in my original workbook are being populated using a formula, so the fraction itself isn't hard-coded into the cell, but rather is being generated via a vlookup/index-match formula that looks within sheets and returns that fraction (just mentioning that detail in case it might interfere with the conditional formatting).

I've attached a workbook to hopefully better illustrate the solution I'm trying to get to.

Darko