View original (French)

Copy the formatting of one cell to another cell

GGdeon Posted messages 3 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -

Hello,

I have a table in LibreOffice Calc with values and then in a column the labels with a defined color. I want to copy the format associated with the label into the result of a VLOOKUP (recherchev) in another table.

How can I do this? 


4 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     

    Hello, and welcome to the new member.

    You are lucky to have found a remarkable forum, with very talented members ... However none of us has any clairvoyant powers!

    With information so limited, it is impossible for us to provide you with a precise answer that exactly matches your need.

    In particular, we don’t know how you assign a color to a cell in the first table: just with the cell formatting tools, or by using the conditional formatting tool, which would be an excellent approach on your part!

    And if you had attached your file to your message, or a sample file, we would have a better chance of finding you a solution ...

    Best regards.

    Well, retirement is good! Especially in the Antilles ...
    Raymond (INSA, AFPA)

    0
  2. GGdeon Posted messages 3 Registration date   Status Member Last intervention  
     

    Hello,

    Thank you for this quick response.

    I don’t know how to attach my file.

    How to do it?

    0
  3. GGdeon Posted messages 3 Registration date   Status Member Last intervention  
     
    0
  4. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     

    Good evening.

    https://file-express.com/fr/open/7a3333253fbb5dffa8cd51ff67889946a1c649f35ea6b06c13

    I have no idea how the software can detect the color of a cell in the first table to apply it to a cell in the second table.

    I think assigning these colors at the start by a conditional formatting would facilitate this color transfer ...

    That's good, retirement! Especially in the Caribbean...
    Raymond (INSA, AFPA)

    0