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
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),"")))