I have a table in a Next Gen Presentation that shows data by quarter in columns. The data is always for a 2-year period, so future quarters shown will be forecast. I'd like to be able to set a Conditional Format on the current year columns that will look at the column header and, if it is "Forecast*", make each cell in the column grey. I can't figure out how to get the Conditional Formatting tool to do this. Please help!
Here's a screenshot of what I've tried. In this shot, I've just used the pink/red format, but the idea is still the same.
*Note: I did already press "Save Rule", this is me going back into the saved rule to edit to grab the screenshot. :)