Hi! Question about conditional formatting in excel:
I have a table in which in the first column there are species names and in the second column numeric values. I used graded colour scale conditional formatting on the numeric values of the second column to highlight visually where I have high numbers and where low numbers.
Now I would like to create a new table in which I have only a subset of the species of the first table. I would like the numerical values for each species to maintain the "colour" of the original conditional formatting of the first table. If I copy paste the cells of interest, then I automatically obtain a new version of the conditional formatting. I do not want my subset of numbers to undergo a new conditional formatting because I want to see from my new table how each species had performed compared to all other species from the original table. I cannot check the "colour" of the original cells to copy RGB values because it's actually not a colour fill.
Any suggestions as to how to solve this problem? Thanks!
Hello Alessandra Aleotti, I never used it for graded colour scale conditional formatting but maybe the format painter of excel is the kind of tool you are looking for. You will find it in the Home tab, in the Clipboard group.
I hope it works!
Best regards
Paul
Hi Paul, thanks for your answer. I have tried your suggestion of using format painter but it doesn’t seem to work for cells that have colour conditional formatting (it works for cells that are colour filled though). Unless there is a more advanced usage of format painter rather than just clicking on the cell with the format to copy and then the cell where you want the format to be pasted… I will look in to that. Anyway thanks!
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column