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.
But MAX(20,8) is the same as MAX(8,20). Both formulae return 20.
You want to have the cell coloured red if the number 20 was first and green when is was the second number? Don't think this is possible.
You could achieve something like what you describe with conditional formatting when you use two columns of numbers. See attached.
Yes, both will return 20 and there I want something to colour them. Red if its a 20 from max(20,8) and green if its 20 from max(8,20)
Thanks for suggestion but I don't have values in separate cols.
Thanks for suggestion but I don't have values in separate cols.
Why not simply upload a sample workbook with some dummy data along with the desired output mocked up manually to show what exactly you are trying to achieve?
- 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.
