Ask Experts Questions for FREE Help !
Ask
    Sudeep Raghav's Avatar
    Sudeep Raghav Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 11, 2012, 02:26 AM
    Ask a question about excel 2007
    We have lot of no in a row, we want to highlight or know which are duplicates
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 11, 2012, 01:20 PM
    You can highlight the row of data and use CONDITIONAL FORMATTING to color the cells that are duplicated.

    If the cells were in row2, you would:

    1) Highlight Row2
    2) Open Conditional Formatting

    Apply a new custom rule with the formula:

    =COUNTIF(2:2, A2)>1
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

2007 excel [ 2 Answers ]

I've progressed from 2003 to 2007 office. I am preparing a report that requires entered data in three adjacent columns. To condense the visual report I want the entire column on one sheet of paper. I've searched the ribbons only locating the page break. In excel 2007 how can I break the column at...

Excel 2007 Question: How do I Keep the Full Screen View on when I Multi-task? [ 1 Answers ]

I had it working perfectly and then I somehow lost it. Every time I click on full screen it takes away all the junk off the top of the screen which is what I like. However when I put the excel screen to a small half screen so I can multi-task other work it goes back to normal screen, putting all...

Question about Dynamic Range for Pivot Tables - Excel 2007 [ 1 Answers ]

I have tried writing a module that will create a pivot table in a named worksheet with a range of data that changes from day to day. I was able to do with easily in Excel 2003 but when I tried to duplicate that in Excel 2007, it doesn't work. It fails with a Run-time error 5: Invalid procedure...

Five task in the insert tab that are common to Microsoft woord 2007 and excel 2007 [ 0 Answers ]

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

View more questions Search