LinkBack URL
About LinkBacks
Sample.xlsx
Please refer to the attachment. What I need to do is to group the same numbers together and highlight with different colors. Do you think it is possible? Thanks for your help.
Sample.xlsx
Please refer to the attachment. What I need to do is to group the same numbers together and highlight with different colors. Do you think it is possible? Thanks for your help.
Last edited by ypurcaro; 01-02-2013 at 02:02 PM. Reason: Wrong file format
Hi
Not used 2003 but if you have conditional formatting highlight duplicates will do it for you
Chris
Click my star if I helped Thanks
why are you posting a word document when you are asking an excel question?
please upload the sample workbook
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
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
I'm so sorry, I thought I just posted an image. I apologize.Originally Posted by FDibbins
if you convert the entries in column A to values, instead of text that looks like values, you can use Conditional Formatting for what you need.
highight all the entries in A, then scroll back up to the top. look for the little yellow diamond on the right habd side of the top cell, click it and select "convert to number"
then, with the cells still highlighted, go into CF, delete the rule you have there, select new rule, "format cells based on their values", select either 2 or 3-colors
Yes, I did convert to number. I think I should use the word "repeat" instead of "same numbers". On column A, you will see some numbers are repeated. I want to highlight that group. Otherwords, I want Excel to go thru the column, then highlight with different color for those have same numbers.
I did the conditional formatting, I use the rules type: Format Only Unique or Duplicate Cells. Doesn't work.
perhaps you missed the bolded part in my previous post?
and please do not "reply with quotes" unless you are trying to high-light something from a previous post
Hi
As FDibbins post #5. Another option with a formula to apply banding, easier to read. In column C: C1 = TRUE and then in C2 and copy down: =IF(A1=A2,C1,NOT(C1))
Go to Conditional Formatting > New Rule > Use a formula etc > Enter: =$C2 & Format as required.
You can hide column C or whatever column you used! See the attached.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
FDibbins and Kevin, thank you very much for your help. Without your help, I would never thought of this because this is not at my level. When I look at the formula, I get very confused. If we translate the formula =IF(A1=A2,C1NOT(C1))to plain English, it would be - to compare the cell A1 and A2, if they are same, go to C1; otherwise do not, am I right? Now, A1 has no value, it's just text and C1 was blank.
CONDITIONAL FORMATTING.xlsxOK, I got the True and False part but look at the formatting. What have I don't wrong? Please take a look my file. Thanks for your help.
Hi ypurcaro
Looks like it is working to me, it is banding as you required (Grouped together)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks