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
Bookmarks