+ Reply to Thread
Results 1 to 2 of 2

Basic IF function

  1. #1
    Registered User
    Join Date

    Basic IF function

    I haven't used excel in a couple of years and my current position requires me to use it. Need help with a what is probably a very basic function for people who use it with any regularity.

    I need to sum a column (i.e A2:A5), I need the sum listed and the cell to be highlighted yellow for totals over 0, and red if the total is 0.

    Pretty basic but can't quite remember how to do it. Thanks for any help.


  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    Mississauga, CANADA
    MS-Off Ver
    =Sum(A2:A5) will sum the values,

    Then you select the cell with the total and go to Format|Conditional Format and choose Cell Value Is from 1st drop down and select Is Greater than from 2nd drop down and enter =0 in formula field.

    Then click Format and choose colour or style from Font tab.

    Click Ok.

    Click Add.

    Repeat above choosed Is Equal To and entering =0 for 2nd condition.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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