stephenclarke111111111
New Member
- Joined
- Dec 8, 2017
- Messages
- 16
Hi,
I'm trying to highlight cells that = "0" in a row but only up to a total of what's in column "E" and leave anything in the same Row after the total is achieved.
Example below, top half is what I have, then below is the result I'm after.
So, the top row only has the first 3 cells highlighted as the total is 3 and leaves the remaining cell that equals "0"
Then the row below is 5 free and I have 5 cells the equal "0" so all get highlighted.
Look forward to any help.
Thanks.
I'm trying to highlight cells that = "0" in a row but only up to a total of what's in column "E" and leave anything in the same Row after the total is achieved.
Example below, top half is what I have, then below is the result I'm after.
So, the top row only has the first 3 cells highlighted as the total is 3 and leaves the remaining cell that equals "0"
Then the row below is 5 free and I have 5 cells the equal "0" so all get highlighted.
Look forward to any help.
Thanks.