I have a table (see attached) that does a vlookup to find values. If the values are above a certain number (this changes per row) I want that cell to turn red.
Conditional formatting DOES NOT WORK because the values are actually a formula, and because sometimes the values have the < symbol.
This sheet will grow infinitely, and I don't want to have to manually apply conditional formatting with every update.
See attached sheet for more notes.
In my sheet I've split all the data out such that if there was a way to apply color via an if-then statement in the cell, what I want could be easily achieved. However, I have no idea if such a formatting statement exists. Ideally it would look something like: