Hello all, first post here.
A little back ground info that may (or may not) be relevant to the questions. I work at a large home improvement company and am keeping track of the sales for our various salesmen, door-to-door canvassers, and telemarketers. I'm running a query in Excel and pulling live data from our Project Management software. From this table, I'm making dozens of Pivot Tables for each salesman/canvasser/telemarketer. So here's an example of one canvasser's sales...
1) After I refresh the data, the new sales come in black color. How can I get it so that when I refresh, any new sales come in blue color? I'm manually changing the new sales from black to blue every week. For 40+ people, this is tedious, but not terrible. Is there a way to set a default format for the Pivot Table (font, color, size, etc.)?
2) After a job has been installed, paid, and cashed out, I have another Pivot Table for these jobs as well on the same worksheet. After I refresh the data, any job(s) cashed out will "jump" from the Sales Pivot Table to the Cashed Out Pivot Table. Any new cashed out jobs will again be black color white background.
These will be the jobs that they will be paid on for this week's check. I then change the row color to the green color to know it's been paid on. This I do want to do manually and not automatically as I'll know any names with a white background needs to paid on this week.
However, for one person in particular, I don't know how or why, but it retains its blue font color, which I really like, but cannot figure out why it's only doing this for this one person and would like to do this for everyone's cashed out sales Pivot Tables.
Any help on either would be greatly appreciated.
A little back ground info that may (or may not) be relevant to the questions. I work at a large home improvement company and am keeping track of the sales for our various salesmen, door-to-door canvassers, and telemarketers. I'm running a query in Excel and pulling live data from our Project Management software. From this table, I'm making dozens of Pivot Tables for each salesman/canvasser/telemarketer. So here's an example of one canvasser's sales...
1) After I refresh the data, the new sales come in black color. How can I get it so that when I refresh, any new sales come in blue color? I'm manually changing the new sales from black to blue every week. For 40+ people, this is tedious, but not terrible. Is there a way to set a default format for the Pivot Table (font, color, size, etc.)?
2) After a job has been installed, paid, and cashed out, I have another Pivot Table for these jobs as well on the same worksheet. After I refresh the data, any job(s) cashed out will "jump" from the Sales Pivot Table to the Cashed Out Pivot Table. Any new cashed out jobs will again be black color white background.
These will be the jobs that they will be paid on for this week's check. I then change the row color to the green color to know it's been paid on. This I do want to do manually and not automatically as I'll know any names with a white background needs to paid on this week.
However, for one person in particular, I don't know how or why, but it retains its blue font color, which I really like, but cannot figure out why it's only doing this for this one person and would like to do this for everyone's cashed out sales Pivot Tables.
Any help on either would be greatly appreciated.
