Conditional Formatting across two tables?

Morning,

I have attached an example spreadsheet to illustrate what I am trying to do; my actual spread sheet with real names, etc is vast in comparison which is why I'm trying to find away around entering into every cell.

I am trying to conditionally format cells in the table in Sheet 1 to either red if the value is below, orange if the value is the same and green if the value is higher, e.g

Each cell in the sheet 1 table checks the value in the corresponding cell in the table on sheet 2 and changes to the colours above.

Any ideas how I can do this without entering a conditional formating formula in each cell, as on the real spreadsheet there are hundreds of cells in the table.

Many thanks

Hello

A simple way is to copy-paste the table2 to sheet 1. Then hide this table.

Then in Conditional Format rules, using simple formula, like =B2=H2, or =B2>H2.....you do the job..

Hope that this, helps you.


Edit: Highlight your range(in your example B2:E6) and type the simples formulae..

No need extra table in sheet 1

Look on the attachment.