Changing the colour of a cell based on =min formula pick

New Contributor

Here is my Issue, i would like to carry over the colour of the coloumn header based on the =min forumla decison, what would be my best way to do this


4 Replies



Here is an example with conditional formatting, if you want it exactly as in the picture, then please insert a file.


I would be happy to know if I could help.


I wish you continued success with your Computer



I know I don't know anything (Socrates)


* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

best response confirmed by allyreckerman (Microsoft)


Not sure I understood the logic correctly, that could be rules with formulas as


Please check in attached file.

@Sergei Baklan 


Thank you so much, it worked.