Excel filtering

Question

Hi all,&nbsp;New to the forum so Hi!!&nbsp;Just after a little help, not sure if Excel can do what I want it to do so I thought I'd ask on hear.&nbsp;I have the following spreadsheet (extract) set up with a conditional format in each day cell to turn the cell a certain colour depending on the number entered ie:&nbsp;1 - RED2 - GREY3 - PURPLE etc etc.&nbsp;What I want to know is, is there a way to filter to show for example just the cells that are 'RED' but maintain the date column and number rows?MONTHSJanuaryFebruaryMarchAprilMay11&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;1&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;74&nbsp;&nbsp;&nbsp;&nbsp;8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9&nbsp;&nbsp;10&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;8&nbsp;132&nbsp;&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I can attached a copy of the document if that would help?ThanksClive&nbsp;

lorenzo kim · Answer

looks like nobody is picking up your query.I don't know if I get you right but pls look at the attached file,hope that you may work something out of it.thanks..

lorenzo kim · Answer

pls find as attached a much "user friendly" version.hope you can make something out of it.thanks..

Forum Discussion

Excel filtering

2 Replies

Resources

MONTHS	January	February	March	April	May
1	1
2		1
3
4					1
5
6
7	4
8
9			10
10
11
12				8
13	2
14
15