+ Reply to Thread
Results 1 to 6 of 6

Excel help - how do I highlight this cell in excel when it doesn't add up? (More complex)

  1. #1
    Registered User
    Join Date
    03-20-2017
    Location
    London
    MS-Off Ver
    MS Office
    Posts
    3

    Excel help - how do I highlight this cell in excel when it doesn't add up? (More complex)

    Cell A1 = 10,000

    The usual way to calculate this would be:

    =SUM(A2:A4)

    E.G.
    A2 = 5,000
    A3 = 2,500
    A4 = 2,500

    However, I want my colleagues to enter the numbers without automating the formula "=SUM(A2:A4)".

    However, I don't want to autosum cell A1, but I want to create or use a formula that will highlight that cell A1 doesn't equal A2:A4.

    Any advice on how to do this?

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    1,826

    Re: Excel help - how do I highlight this cell in excel when it doesn't add up? (More compl

    Welcome to the board
    Something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in another cell

    Or would you prefer cell A1 itself to be highlighted?
    Last edited by kev_; 03-20-2017 at 07:21 PM.
    To acknowledge help given click *Add Reputation
    To mark thread as SOLVED - see Thread Tools at top of thread
    To attach a file - click REPLY ... GO ADVANCED ... look below for MANAGE ATTACHMENTS etc

    Always ask for an explanation if anything is not clear

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    2010, 2013, 2016
    Posts
    10,305

    Re: Excel help - how do I highlight this cell in excel when it doesn't add up? (More compl

    You can add a conditional formatting rule for A1 that says

    =A1<>SUM(A2:A4)
    Jeff

    Making the world a better place one fret at a time | | || || || || | |:| | || ||

    If someone helped you, please click on the star icon at the bottom of their post
    If your problem is solved, please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  4. #4
    Registered User
    Join Date
    03-20-2017
    Location
    London
    MS-Off Ver
    MS Office
    Posts
    3
    Quote Originally Posted by kev_ View Post
    Welcome to the board
    Something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in another cell

    Or would you prefer cell A1 itself to be highlighted?
    To highlight the cell after this is registered...

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    40,792

    Re: Excel help - how do I highlight this cell in excel when it doesn't add up? (More compl

    Quote Originally Posted by pagrant View Post
    To highlight the cell after this is registered...
    Did you see 6String';s suggestion above?

    If you are unfamiliar with Conditional Formatting...
    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A1<>SUM(A2:A4) Format Fill as needed
    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 some-1 helped you

    Regards
    Ford

  6. #6
    Valued Forum Contributor
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    1,826

    Re: Excel help - how do I highlight this cell in excel when it doesn't add up? (More compl

    My earlier post as a conditional format is illustrated in attached workbook

    conditformat102.jpg
    Attached Files Attached Files

+ 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