Hi,
Is it possible to use conditional formatting to select a particular text filter for a pivot table based the day of the week (which is automatically updated in cell A1 for example)?
E.g. if today was Sunday, then the filter on the pivot table would select filter for Sunday or multiple filter entries if required?
Any help with this formula would be appreciated.
Is it possible to use conditional formatting to select a particular text filter for a pivot table based the day of the week (which is automatically updated in cell A1 for example)?
E.g. if today was Sunday, then the filter on the pivot table would select filter for Sunday or multiple filter entries if required?
Any help with this formula would be appreciated.