In the image you can see that there are values in the row 1 and in column A. I change the values in column and check the checkmarks. Based on those values I want to colour the calls in the area B2:G9. For every call in the range(E.g B2) if the value in the calumn A left from it(E.g A2) is higher than the value in the row 1 on top from it(E.g B1) of that cell then I want to colour it(E.g B2).
Can I achieve this with one rule or do I need to make a rule for every cell? What range do I chose?