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.
Hi,
attached is an example file how my data is looks like and how results should be coloured. in attached colours are done manually just to show the desired outcome.
~Thanks all for looking.