You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Posted on Nov 17, 2024 9:47 AM

Reply
2 replies

Nov 17, 2024 3:35 PM in response to Mana-Mahad

Hi

Mana-Mahad,


Here is one way. We are going to use a filter (Text is Show) on the High Score table.


Stamina has a Header Row.

High score has a Header Row and a Footer Row.

In High score, add rows with images of every character in the game.

Formula in B2 is IFERROR(Stamina::B2,"") to copy the scores across. (IFERROR is to cater for characters that do not yet appear in Stamina).

Formula in Footer Row of column A is MAX(Stamina::B)

Formula in C2 is IF(B2=A$8,"Show","") and Fill Down. (that puts Show next to the character with MAX score).


Add another row to Stamina and fill A with the new character image. Type the score for the new character in B.

You might need to fill down the formula in High score B.



The new MAX (58020) has placed Show next to the new character.

Filter the High score table:



And hide columns B and C:



Regards,

Ian.

Nov 18, 2024 3:52 AM in response to Yellowbox

Hi Ian!

Thank you for taking the time to answer my question.

Unfortunately, this is not what I was looking for, because I still need to manually copy and paste the image of the character to the "high score" table every time a new character is added and fill down the formula in B.

I was maybe thinking about writing a script to help me do that in one click but I'm a real beginner so I'm still trying to learn the basics, haha.

Have a good day!

Is there a way to copy the format (background) of a cell to another one ?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.