Using excel 2010. i have a table (table 1) with row b name, row g amount. Positions in table vary from day to day i have created a colour shading table (table 2) from dark red to white. When i organise row b to largest to smallest they are link to the table with the colour shade. Now the problem is my 3rd table need to be in alphabetical order with the colour shading taken from table 2. Currently doing this manually, is it possible to create a link that will update the colour that the name is in automatically
Solved by Z. S. in 27 mins