Comments on: Format Painter and other ways to copy formatting in Excel

Microsoft Excel has an amazingly simple way to copy formatting, which is often overlooked or underestimated. This tutorial shows the most efficient ways to use Excel Format Painter, Fill Handle and Paste Special to copy formatting to a selected cell, range, entire column or row. Continue reading

Comments page 2. Total comments: 31

  1. Hey guys!

    I enjoy a lot your post, maybe it is not the forum; I could not find in others posts or people questions.
    I have a pivot table which brings names and on the left column there are a formula bringing two options of codes and I am trying to do the conditional formatting, like cell not equal " " has border. However, I could not find a way to do it, the spreadsheet brings border table blank and it is "not clean" as report to send to agents. I tried formulas as =formatatext or blabla,A=fastrac...

    Nothing helped, do you have idea how I can do it? It is necessary to be kind of "automatic" format as the pivot functions to others select something and check the information in the clean way.

    Thank you so much!

    Cris

    IFERROR((VLOOKUP($C11,'Agent database'!$B:$AT,7,FALSE)),(IFERROR(VLOOKUP($C11,PAULA_AG_SU16!$S:$T,2,FALSE),"")))

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)