I am looking for a way to color the lowest number in a group, but some of those numbers are first divided by two.
2 2
3 3
Say I am assembling bicylces and row 1 = frames, row 2 = wheels. I want to show what I run out of first when I want to build bikes. I have 2 frames, 3 wheels so I want to color the cells showing a 3 in red.
only that formula does not work, is there a way to have this work?
edit: removed formula as it was incorrect and caused confusion
Bookmarks