Hi all
I know my way around Excel but have never really used Pivot tables much until now.
I've created one which seems to do what I want but the conditional formatting is causing me trouble.
I have a number of names (rows) and a number of different types of training (columns) and the pivot table pulls in the latest date for each person for each type of training. That bit works ok.
I want to apply conditional formatting which will highlight when specific training is out of date, but each type of training has a different duration. So far, I can only apply a single date to the whole table, whereas I want to have a separate rule for each column.
Is this possible?
I know my way around Excel but have never really used Pivot tables much until now.
I've created one which seems to do what I want but the conditional formatting is causing me trouble.
I have a number of names (rows) and a number of different types of training (columns) and the pivot table pulls in the latest date for each person for each type of training. That bit works ok.
I want to apply conditional formatting which will highlight when specific training is out of date, but each type of training has a different duration. So far, I can only apply a single date to the whole table, whereas I want to have a separate rule for each column.
Is this possible?