Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Ask a question about excel 2007 (https://www.askmehelpdesk.com/showthread.php?t=681378)

  • Jul 11, 2012, 02:26 AM
    Sudeep Raghav
    Ask a question about excel 2007
    We have lot of no in a row, we want to highlight or know which are duplicates
  • Jul 11, 2012, 01:20 PM
    JBeaucaire
    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

  • All times are GMT -7. The time now is 01:42 PM.