Hi
I want to highlight only the cells that have the same name repeated more than 5 times between 2 columns.
The formula below works except when entering formula into conditional formatter in excel it highlights all the cells from D4:E10 which contains other names.
=SUMPRODUCT((D4:E10="Billy")*(D4:E10>5))
cam.PNG
Basically If Billy is repeated more than 5 times I want to highlight all Cells containing Billy within cells D4:E10.
I appreciate any help on this
Please Login or Register to view this content.
Ben Van Johnson
So I entered this:
I did this and all it displayed False. After selecting the required cells D4:E10 and entering the above formula in formatting condition nothing happened.Please Login or Register to view this content.
Apologies if I'm miss-understanding
The formula in post #2 is a replacement for your original formula, use it by itself as given, not attached to your old formulas.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks all - Did as requested and it works. Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks