I need help with calculating the percent through the month and quarter in a couple of different views.
The first is a straight text box that will display the percent through the quarter.
The second is for conditional formatting. I have a pivot table with each month's performance compared to budget. I would to have conditional formatting for the percent through the month for each month. Therefore, since March is 100% over, anything over 100% is green. However May is only 3% through the month therefore anything over 3% would be green.