• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting only on selected columns

abrpanch

New Member
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.
 

Attachments

  • sample file for lowest cost of plant.xlsx
    9.9 KB · Views: 6
See conditional formatting in the attached.
1750897416598.png
 

Attachments

  • Chandoo58631sample file for lowest cost of plant.xlsx
    10 KB · Views: 4
More convoluted than I thought. See attached.
 

Attachments

  • Chandoo58631sample file for lowest cost of plant_v2.xlsx
    10.7 KB · Views: 4
Back
Top