+ Reply to Thread
Results 1 to 3 of 3

conditional formatting and blank cells

  1. #1
    Registered User
    Join Date
    01-25-2012
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    8

    conditional formatting and blank cells

    im comparing two different columns. One colomn is a manual input (me putting in scores) the column being compared is what the actual score is. Im trying to right a simple format if cell a1 does not equal cell b1 highlight red, if they are equal, no highlight.
    problem is there are spaces between the rows as i work down the sheet, and the conditional formatting is highlighting these blank cells red even though there is no value in the cell. i used the same format in excel 2007 w/ no problems. any idea why excel is highlighting these blank cells???

    thanks in advance.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,962

    Re: conditional formatting and blank cells

    If both A1 and B1 contain values and A1 not equal to B1 (red):
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: conditional formatting and blank cells

    try this, depending on which way round you are looking...

    =AND(a1<>"",a1<>b1)
    =AND(b<>"",a1<>b1)
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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