I have a table of assets with a Date Purchased column and an Age column using =DATEDIF(C3,TODAY(),"Y")&" Years, "&DATEDIF(C3,TODAY(),"YM")&" Months" - there are also Location and Category (of asset) columns ...
The Age column then has conditional formatting that fills the cell green/amber/red depending on the age of the asset, which supports filtering by fill colour/simple way to get at a list of older assets ...
I now want to create a view of assets by Location, by Category - so far so good in a (simple!) Pivot table - but I then want it by Age (Band) ie the conditional formatting colours but I can't find a way to do this in a Pivot Table ...
Is it possible, or am I going to have to revert to another approach?
Thanks ...
The Age column then has conditional formatting that fills the cell green/amber/red depending on the age of the asset, which supports filtering by fill colour/simple way to get at a list of older assets ...
I now want to create a view of assets by Location, by Category - so far so good in a (simple!) Pivot table - but I then want it by Age (Band) ie the conditional formatting colours but I can't find a way to do this in a Pivot Table ...
Is it possible, or am I going to have to revert to another approach?
Thanks ...