In the attached spreadsheet, I have a limit value which is used to set the color of other cells based on their values.
So if the value is greater than limit, the color is red.
When I change the limit, I do see the changes in color.
However, I also want to show only the red values.
How do I do that?
Can anyone please reply?
Hi,
Kapilrakh,
Just filter col D using "Filter by Color", which will show only the red values
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
Forum rules require you to wait at least 24 hours before bumping your thread. A little patience goes a long way
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
But I will have to do this manually every time I change the limit value. I want "Filter by Color" to be done automatically when limit value is changed.Originally Posted by rajeshturaha
For this you will need VBA, I will move your thread to that forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks