Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter a coulered cell range?
I have a range that contain a coulored cells in red yellow and green (for
example), How can I fillter the yellow cells? I use office 2007 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter a coulered cell range?
First turn on AutoFilter:
Office Button Sort & Filter Filter The touch the pull-down and Filter by Color -- Gary''s Student - gsnu201001 "haliem" wrote: I have a range that contain a coulored cells in red yellow and green (for example), How can I fillter the yellow cells? I use office 2007 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter a coulered cell range?
Place the cursor in Header Row (i.e. row 1) and press Alt+D+F+F which will
apply the filter for your data and now select the column which is formatted as Red and yellow Press the drop down and select Filter by Colour. In filter by colour drop down you can see the colours which are all applied in the present column Select the Red or yellow colour and press ok. Now it will show only the data which is formatted as Red or yellow Colour. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "haliem" wrote: I have a range that contain a coulored cells in red yellow and green (for example), How can I fillter the yellow cells? I use office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter range | Excel Discussion (Misc queries) | |||
use "Filter" to filter one range in many worksheets at a time | Excel Worksheet Functions | |||
Set external cell filter for a range | Excel Discussion (Misc queries) | |||
named range with filter | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |