hasanlianar
New Member
- Joined
- Jul 21, 2011
- Messages
- 43
Hi,
I have a table and there is a "Status" column in that table. The Status column contain statuses "done" and "done" colored in green (either font color or fill color). There are also empty rows in this column. I want to first filter not empty rows, so I choose "done" in filter. Then I want to filter the "done"s which are not colored in green. I do it by choosing "FIlter by color" and then "no fill" in Filter window. But in this case empty rows also appear. I dont need empty rows. What I need is statuses of "done" not colored in green.
Could someone help on this?
I have a table and there is a "Status" column in that table. The Status column contain statuses "done" and "done" colored in green (either font color or fill color). There are also empty rows in this column. I want to first filter not empty rows, so I choose "done" in filter. Then I want to filter the "done"s which are not colored in green. I do it by choosing "FIlter by color" and then "no fill" in Filter window. But in this case empty rows also appear. I dont need empty rows. What I need is statuses of "done" not colored in green.
Could someone help on this?