Formating a box depending on the values

[Cmorgan]

Morning,

I'm working on the sheet REPORT:

- on the top page I have a table of values
- on the lower page I have the same table but different values in it

What I would like to do is colour code the top table to show if the value in the cell is lower (red), the same (orange) or higher (green), e.g.

E6 has 80%, the corresponding cell of E33 has 99%. As E6 has a lower value I would like it to turn red.

I'm not sure how to do this via conditional formating.

Any ideas it would be greatfully appreciated.

Many thanks

[tom1977]

Hi
there is something wrong with your file (my computer can't save this) but try to use such formula in Conditional Formatting like
=e6>e33
=e6=e33
=e6<e33
on range of first table
and set colors what You want

[Cmorgan]

Thanks, but when I open the attachment it appears unrelated.

[Cmorgan]

Many thanks