Dec 09 2019 07:04 AM
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)
I want to have number1=red and number2=green so Max(20,8) will show 20 in red and vice-versa.
Thanks all for looking.
Dec 09 2019 07:19 AM - edited Dec 09 2019 07:26 AM
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.
Dec 09 2019 07:42 AM
Dec 09 2019 07:52 AM
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?
Dec 09 2019 08:20 AM
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.
Dec 09 2019 08:21 AM
Dec 09 2019 08:40 AM
SolutionYou 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.
Dec 10 2019 01:07 AM
Dec 09 2019 08:40 AM
SolutionYou 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.