Forum Discussion

raghujai07's avatar
raghujai07
Copper Contributor
May 31, 2021

Conditional formatting with IF function and Minimum function

I am finding the minimum calue of each cells in è different tables and need to return the lowest value to the 1st table along with the cell colour. Kindly help me. Thank you, Raghu

This is the formula I used

=IF(MIN(B14,L14,B26,L26,B37,L37)="L37",TRUE,FALSE)

excel
office 365

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 31, 2021

    raghujai07 

    If to colour cells without VBA, using conditional formatting rules, you need as many rules as colours do you have. With that in current logic you may use formulas for the rule like

    =B3=$B$26:$I$33

    for the blue colour, applying the rule to $B$3:$I$10

    Same for other colours.