Match each cell of an array with another array

[bonniebarca]

Hi guys
Need help!!

I have two tables, TABLE_TARGET & TABLE_ACTUAL. These are cash flow tables, one target and another actual, in two tabs of the same excel sheet. Both table has 250 rows and 12 columns, meaning 250 items and 12 month cash flow for each item.

Now I want formula for changing cell color automatically based on the value I put in each cell of TABLE_ACTUAL.
Example, If Item A has cash flow target of $20000 in Jan 2021 and $25000 in Feb 2021 in TABLE_TARGET, and if I put $22000 and $23000 in corresponding cells in TABLE_ACTUAL, it should automatically turn Jan cell RED and Feb cell GREEN in TABLE_ACTUAL.

Really stuck, kindly help!

[TMS]

Post a sample workbook. See the yellow banner at the top of the page.