sometimes i need to filter color wise datas. sometimes color based on background and sometimes based on text color.
i am using office 2003. can any one help me out.
attaching reference file for two sheet.
regards,
ryan
sometimes i need to filter color wise datas. sometimes color based on background and sometimes based on text color.
i am using office 2003. can any one help me out.
attaching reference file for two sheet.
regards,
ryan
You could add extra column with this macro function so you will be able to filter by that column.
what about the back ground color mode in sheet1 ? sorry for duplicate, i didnt find my question, so i had do put that again.
Here.
use formula:
=BackColor(E2,TRUE) - for background color
=FontColor(E2,TRUE) - for font color
Hi zbor,
sorry for coming back with this issue lately. after working with this vba that you inserted, it seems it is not taking
background colors that are happened by conditional format.is that possible to find the color name which has been done by conditional format so that i can easily filter ?
attaching file
thanks,
Ryan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks