Is there a way to copy the format (background) of a cell to another one ?
Hello
I'm using a table to rank different characters from a game based on their stats.
Here, I created a table named "stamina" with 2 columns.
Column A with the face of one character in each row.
Column B with the HP stat of that character.
I have added a second table named "high score" with only one column and 3 rows
1st row is just a text row
2nd row should be displaying the face of the character from the "stamina" table with the highest HP stat.
3rd row should display the highest HP stat from all the characters based on the "HP" column. I used the simple MAX(Stamina::B2:B5) formula.
Now, what I'm struggling to do is displaying the face of the character with the highest HP stat in the second row (cell A2).
I could simply copy and past the style of the A2 cell from the "stamina" table to the A2 cell from the "High score" table, but there's more than a hundred characters in the first table, the game is constantly adding new characters and each character has multiple stats (HP, ATK, Speed...) so I can't manually update each character one by one as it would be too time consuming.
Here is what I want my "high score" table to look like when a new character with the highest amount of HP in the game is added.
*4 characters in "stamina", the highest HP stat is "54,850", the "high score" table displays the face of the tankiest character in A2, and the highest HP value in B2*
*new character added in the "stamina" table with higher HP than the previous one, the "high score" table updates the face of the tankiest character in A2 and the the highest HP value in B2 thanks to the MAX formula*
I know a simple formula unfortunately can't refer to a cell background because it's not a data but a format, but is there a trick to have a similar result?
Thank you.
MacBook Pro 14″, macOS 15.0