Could someone please help me with this problem
I have attached a sample sheet, what I need is a macro that will highlight all lines that appear on my worksheet 3 times or more.
The data to look at will be in Column G, when the numbers in there appear 3 times or more I would like Columns A – L need to be highlighted
Many Thanks
How about just using conditional formatting.
In column M beginning with M2 and copied down...
=COUNTIF($G$2:$G$46,G2)
Then...
Conditional Formatting
- Highlight applicable range >> A2:M46
- Home Tab >> Styles >> Conditional Formatting
- New Rule >> Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =$M2>2
- Format… [Number, Font, Border, Fill]
- OK >> OK
HTH
Regards, Jeff
Instead of a Macro, why not just use conditional formatting?
1. Select your range (in your example file the range is A2:L46)
2. Click Conditional Formatting and use the following formula as criteria: =COUNTIF($G:$G,$G2)>=3
3. Choose how you want the matching cells formatted and click OK.
- Moo
If you rather a macro...
Please Login or Register to view this content.
wow Thanks for the quick response, i would prefer a macro if possible. Jeff i have tried your Macro but nothing seemed to highlight.
Try this...
Hi Jeff
That works well, thanks for all your help. Problem Solved
Last edited by SilverFox; 11-20-2012 at 05:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks