I am creating a month by month summary of my school demographics. The first column has the target for our enrollment and then the columns to the right have each months results. My goal is to be able to highlight the target in yellow and then the current month only in green. I do not know how to isolate specific columns for coloring.
I know how to color the highest number or the lowest number. I know how to color all numbers below or higher than a certain number, but I do not know how to color an entire column (regardless of the number).
But, the idea for this project is that I will have the months of Sept through May and I want the column with our target highlighted and the current month only.
Can anyone helps on this with a calculated field? Thank you.
~ Peter
Thank you so much. I found some code on another post that actually worked...the code is
if [Month]='Target' then 'Target'
elseif [Month]='Sept' then 'Current Month'
else 'white'
end
This is perfect...as I can keep the target highlighted and then each month I just change the month to the current month.
This is great...but I know the next question will be "is there a way to color the title "Target" and the current month "Sept" with the same color? Solving this would be the icing on the cake.
