Results 1 to 12 of 12

Auto value colour display with =sum - small formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Gibraltar
    MS-Off Ver
    Excel 2007
    Posts
    6

    Auto value colour display with =sum - small formula

    Hi All,

    I am hoping you guys can help me out here as i have been tearing my hair out over this one. i have an excell sheet with the following fields:

    R.1 R.2 R.3 R.4 R.5 R.6 TOT PTS
    78 63 53 66 47 0 307

    Now upto here easy enogh, my TOT PTS filed is populated with the following formula: =SUM(F3:K3)-SMALL(F3:K3,1), basically adding the 5 biggest values out of R1:R:6, now the tricky part that i can t figure out, how do i get the smallest value, therefore the one which is taken out by -SMALL(F3:K3,1) in the formula, to be automatically displayed in RED???

    I have tried using conditional formatiing but my knowledge on that is very slim so any advice is welcome. Thanks.
    Last edited by NBVC; 06-25-2009 at 08:00 AM.

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