It much eaiser if you add example workbooks so that we dont have to spend time recreating the senario.

This conditional formatiing should work - i find it easier to do the rule then paste it into the conditional formatting formula box

Attached Files

How to compare two cells in a worksheet and show the result as red or green in a cell another w.xlsx (10.5 KB, 8 views)