So I have a list of numbers in sheet_A associated with a list of names, and then I apply the traffic light icon conditional formatting so that they have a relative conditional formatting in the list.
Now can I somehow show a value from sheet_A in sheet_B which maintains and shows the icon conditional formatting based on the sheet_A list?
I want to create a dashboard for each name on the list from sheet_A, and show the relative performance of the number in other sheets by keeping the traffic light conditional formatting based on the sheet_A list. So if on sheet_A the number performed as green, I want to link that to sheet_B showing the value and maintaining the green traffic light icon.
Now can I somehow show a value from sheet_A in sheet_B which maintains and shows the icon conditional formatting based on the sheet_A list?
I want to create a dashboard for each name on the list from sheet_A, and show the relative performance of the number in other sheets by keeping the traffic light conditional formatting based on the sheet_A list. So if on sheet_A the number performed as green, I want to link that to sheet_B showing the value and maintaining the green traffic light icon.
