Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

To delete Rows having been assigned particular colour from selected column and / or to remove t

  Asked By: Cory    Date: Mar 02    Category: MS Office    Views: 1643
  

Is it possible to write macro(s) for the following:1. To delete Rows
having been assigned particular colour from selected column and / or to remove
the particular colour from the selected column?2. When we filter data to display
the number of occurrences of particular entry.It will be best if these options
are incorporated by microsoft it self instead of creating macros for them by the
users.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Christie Bradley     Answered On: Mar 02

Yes you can write  VBA code to check on the colours in cells and then do
whatever you like with them.

When you filter  data, you can use the count facility in the status bar to
tell you how many items there are.

 
Answer #2    Answered By: Wendy Harrison     Answered On: Mar 02

just installed office 2007 buddy it has the option to
sort on color

 




Tagged: