I have a Google Sheet that looks like this:
Column/Row | Value | A1 | 1 | A2 | 2 | A3 | 3 | A4 | 4 | Row with header | A6 | 5 | A7 | 6 | A8 | 7 | A9 | 8 |
And this continues for multiple rows, same format, 4 consecutive values and 1 header.
I need to conditionally format the minimum value in each range to a specified color. So the first range (A1:A4), I want only A1 to be highlighted. I've tried doing this by choosing the custom formula option in the conditional formatting tab and typing in:
but this highlights all values A1 to A4 instead of just A1 and I don't understand why? Manually typing =min(A1:A4) in a cell indeed gives me 1, but I can't seem to get it to work in conditional formatting.
Once we have the conditional formatting down, would it be possible to apply the same formula to multiple ranges? As in, could I just enter my ranges separated by a comma like: A1:A4, A6:A9, ... and have just one conditional formatting rule/formula do this for me? Note that I don't need the minimum value in the entire A column, I need the minimum value in these specific ranges. Been stuck with this for a while, so I'd really appreciate some help.
EDIT: My question did not represent my actual data setup, I apologize for the inconvenience. This is my actual sheet. Please help me highlight the minimum weights for each week. (B4:B10, B12:B18, B20:B26, and so on), ignore the other columns. You can view the formula creations sheet if you're interested in my attempts to do this. I have not granted editing rights with this link, but if you need them, please let me know.