Results 1 to 13 of 13

countif using range in conditional formatting

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    69

    countif using range in conditional formatting

    Several inventory spreadsheets in a workbook, a new one added each week w/ current inventory. Column A=item numbers with a range name. I then use conditional formatting to highlight all cells containing new items. ie.. new arrivals and did not exist in previous week's sheet.

    I do get some cells to highlight correctly and I thought it was working but then I find SOME of those item numbers do exist in the previous weeks sheet. So..... what have I done wrong?

    Very simple but oh so elusive!
    So many questions and so many helpful people here that I can't seem to find this.
    Thank-you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting with countif - dynamic range
    By Stroem in forum Excel General
    Replies: 3
    Last Post: 10-12-2012, 04:36 AM
  2. [SOLVED] Countif and conditional formatting
    By SLKPM in forum Excel General
    Replies: 0
    Last Post: 09-30-2005, 06:05 AM
  3. Conditional Formatting And Countif
    By cafe in forum Excel General
    Replies: 6
    Last Post: 08-10-2005, 03:40 PM
  4. [SOLVED] Countif with conditional formatting
    By Johnny in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2005, 08:06 AM
  5. Countif and Conditional Formatting
    By Ramiro Espinoza in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2005, 02:06 PM

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