Hello,
I am trying to fill a cell with colour using conditional formatting if my condition of lowest value among selected columns [three columns B, C and D] is met with.
Have successfully used a formula B3=MINIFS($B3:$D3,$B3:$D3,">0") and $B$3:$D$12 [three columns B, C and D]. Can see it in sample file attached.
Now want to get the same lowest value to be filled with colour only in columns B and D [omitting column C], and here I am stuck up.
Can someone help to get desired result, please.
Have attached a sample file.
Thanks a lot.
I am trying to fill a cell with colour using conditional formatting if my condition of lowest value among selected columns [three columns B, C and D] is met with.
Have successfully used a formula B3=MINIFS($B3:$D3,$B3:$D3,">0") and $B$3:$D$12 [three columns B, C and D]. Can see it in sample file attached.
Now want to get the same lowest value to be filled with colour only in columns B and D [omitting column C], and here I am stuck up.
Can someone help to get desired result, please.
Have attached a sample file.
Thanks a lot.