Hi,
I have a worksheet that will have conditional formatting in one column that refers to dates, with red being overdue, black being within next few months, and green being beyond that time. I then put that information into a pivot table. What I would like to do however is be able to set up columns that show the values of cells in a respective column dependent upon color, so you can see for example all overdue orders for a customer (shown as red), and in the next column those that show as black, etc. I realise you can filter your data by color of course, however rather than having to do that each time to look at the timeframe I would like to be able to look at it all on one spreadsheet, and then put this info into a pivot table which I can do if I have the data set up this way.
The attached example illustrates what the data set will look like. What I am wanting to do is in column M headed 'Red' only have values show in that column where the cell in column J has red font, and if the font in column J is not red, to leave the cell in column M blank. Same for both columns N & O (being Black and Green). I can then put in subtotals that will show the data for the respective time periods. I have been searching Google and the forum for an answer however have not been able to find one as yet.
Thanks in advance for your help
Will
Bookmarks