+ Reply to Thread
Results 1 to 2 of 2

Conditional format to check for entry presence in multiple worksheets

  1. #1
    Registered User
    Join Date
    11-12-2007
    Location
    Virginia
    Posts
    19

    Conditional format to check for entry presence in multiple worksheets

    I have a spreadsheet with 13 tabs, Template and each month of the year, column A on each sheet is for the repair order number and what I need is a way to alert me if an R.O. number I input is already listed above itself or on any of the other sheets thereby avoiding repeating myself to the accounting department. I have been trying to set up a conditional format based on some of the post answers I have read but I haven't hit on the one that will work both for all the other sheets and the one I'm on also, seems that if I input the number into the name range on the sheet I'm working, it sees itself and therefore it adapts the cf set up for the alert so all the numbers on that sheet are lit up. Can anybody give me an idea that will work??

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Conditional format to check for entry presence in multiple worksheets

    For cell A2 (say) use in CF

    =COUNTIF(A$1:A2,A2)>1 ---> Format Red and paste special formats across the column
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1