I have some cells which I would like to format to display the level achieved for each person:

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 `Table3`

with `$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?

1more comment