Hello
I have a Vlookup table that uses conditional formatting to format the cell type between percentage and number etc I would like the same cells to change colour RED/Green depending on if they are higher or lower than a set value.
I've been playing with if & and formulae to try and achieve it but im not getting close.
Cell B4 holds the Vlookup driver.
In words...
IF B4 = FIR then the table will use conditional formatting to highligh cells higher or lower than 1.02
If B4 = TOC the the table will use conditional formatting to high light cells higher or lower than 90%
Hope this make sense.
Many Thanks
Bookmarks