I’m trying to get a cell to fill green if the formula:

=IF(VLOOKUP(E5, Table3, 3)>VLOOKUP(E5, Table3, 4), TRUE, FALSE)

is true. When the formula is put in a cell, it returns true, but when conditionally formatted, the green fill format isn’t working. Table3 is on another sheet in the workbook, but even when I moved it to the same sheet, it still didn’t work. I’m not sure why the formatting isn’t working when the formula works.