change cell color only if that cells font color is black and it's value is < 2000

Hi,

Not sure I understand your syntax.

Table1[Balance] refers to an entire column of values within the table, not just a single cell.

Are you looping through that column? If so, can we see the rest of your code?

Regards