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