Advance Conditional Formatting | Using "IF" formula?

The formulas go in the Table of Hands-1 table. The cells that are gong to get highlighted are those where the formula result is the value in Table of Hands. The other cells in the table will be blank (null string).

1. In the Table of Hands table, select all cells from A2 to the bottom right corner of the table.
2. Start making the conditional highlighting rule
3. Click the green oval and select cell Table of Hands-1::A2
4. Click the checkmark to accept it
5. Finish making the rule

Possible, most definitely. I'm trying to think of a better or more clever way than this but here a typical way.

Make another table with the same grid of cells.

The formula in a cell of that table would be like one of these (written for cell E2):

=IF(Table 1::$E$1="BTN",Table 1::E2,"")

=IF(OR(Table 1::$E$1="BTN",Table 1::$E$1="UTG"), Table 1::E2,"")

The highlighting rule will be "if text is [cell reference to the other table] then highlight cell"

You can create all the rules at one time by selecting all the cells that need the rule and creating the rule for the top left cell (Table 1::E2) so the cell reference in the rule will be Table 2::E2. It will adjust the cell references for all the other selected cells so they will all point to the correct cells.

To create the cell reference in the rule, click on the green oval (you'll know what I mean when you see it), select the one cell, then use the checkmark to accept it.