Hi,
I have a sheet essentially as follows:
<tbody>
</tbody>
I'd like to conditionally format each cell in column A based off if any of the quantities in the same row exceed the quantity above them on row 1. In this example Order 1 and 3 would be conditionally formatted but not order 2 and 4.
I'd like to avoid using a macro if possible so it will update in real time as orders are added.
Apologies if this has been asked or answered elsewhere but I could not find something similar by searching.
Regards,
Ashley
I have a sheet essentially as follows:
1 | 2 | 10 | 6 | 8 | 0 | 12 | 40 | 6 | |
Order 1 | 2 | 1 | 12 | ||||||
Order 2 | 1 | ||||||||
Order 3 | 1 | 12 | 5 | 3 | 10 | ||||
Order 4 | 1 | 2 | 6 | 1 |
<tbody>
</tbody>
I'd like to conditionally format each cell in column A based off if any of the quantities in the same row exceed the quantity above them on row 1. In this example Order 1 and 3 would be conditionally formatted but not order 2 and 4.
I'd like to avoid using a macro if possible so it will update in real time as orders are added.
Apologies if this has been asked or answered elsewhere but I could not find something similar by searching.
Regards,
Ashley