Hi Excel gurus,
i have two columns A and B
In A (code number) and in B (extn)
A is unique and have more extn assigned to it
All the extn assigned to code number should be equal in Length.
I need a macro to colour a code number if its corresponding all the extn are not equal in size.
i have attached with the example.colouring the cell based on the values of other column.xlsx
Shall we use Conditional Formatting?
Please confirm
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yes.. any how if done by macro means that would be great...
Hi,
This is my approach, using macro.
Select the range (A4:A18) then run the macro.
Please Login or Register to view this content.
You don't even need to sort the data first, look at my attached file, and try to run at range A23:A39.
Regards
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Maybe:
Please Login or Register to view this content.
shows error at ....................mtx(1, i) = cell.Value
John H Davis ... thanks for the helps. ur code works good.
Karedog .... thanks for ur help and quick reply.....
You're welcome. Glad to help out and thanks for the feedback.
You ***MUST NOT*** select A2, just select A4:A18 (or A23:A39) as I told in my previous post.Originally Posted by excelhelpseeker
Or
Please Login or Register to view this content.
hi john,, the macro is fine with the example i provided but doesnot work as i have many codes with atleast 6 or 7 extn for a single code
Not sure I understand. Can you post a sample where it doesn't work?
sample.xlsxyes john i have attached the sample file. pls note that i have empty cells in code or extn....
In your sample from Post#13 with the exception for "QUERY" in Column A all the items are unique. Why would you expect it too work? It's an entire different lay out than what you had from Post #1? If you interchange the columns, it does highlight. Not sure that's what you are looking for though?
Last edited by JOHN H. DAVIS; 11-17-2014 at 10:58 AM.
but the code is at column B...
This switches too Column B?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks