On the right I have a table called Table3 which contains the data of the level achieved by each person. This is shown on the left by a bar graph.
The formula I have in B2 to give me the TRUE and FALSEs for the conditional formatting is:
=VLOOKUP($A2,Table3,2,FALSE)>=B$1. However, if copy and paste this formula into the conditional formatting dialogue box I get an error saying the formula is not valid. If I however replace
$G$2:$H$5 it works perfectly.
So, why does conditional formatting not like my table names, and is there a way to use tables when doing conditional formatting?