Forum Discussion
Solved
Colour code for formula Max(number1, numbr2)
Hi, I am trying to find a way where I can possibly assign colours to each of the numbers used in MAX formula hence the value will be coloured accordingly. for example in formula MAX(number1, number2...
You may apply conditional formatting rule with formula
=C2=VLOOKUP($A2,FC!$A$2:$G$9,@MATCH(C$1,FC!$A$1:$G$1,0),0)for the red and similar for the green. Please see in second sheet attached.
attachment of dummy data posted. Thanks
You may apply conditional formatting rule with formula
=C2=VLOOKUP($A2,FC!$A$2:$G$9,@MATCH(C$1,FC!$A$1:$G$1,0),0)for the red and similar for the green. Please see in second sheet attached.
- Thanks a lot Sergei. It did work perfectly. I had this in back of my mind but didn't want to try because I have +27K rows and +200 columns of data (with 2 Vlookups each cell) so applying this conditional formatting will possibly slows down the spreadsheet but since this is the only solution at the moment that is working so I will give it a try now.
Thanks again for your effort of being helpful.