+ Reply to Thread
Results 1 to 2 of 2

highlight minimum

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    59

    highlight minimum

    Here is what I want:

    I have a column with numbers. I want that the program highlights the minimum (by changing background color for example)

    the code i have is:

    =IF(R28=MÍN($R$26:$R$28);" minimum ";"")

    but this is in another cell, i dont want to say anything, only that it changes the background color of the cell where is the minimum.

    tks for the tip

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500

    Re: highlight minimum

    if you look at conditional formating and put the following in as the condition

    =R28=MÍN($R$26:$R$28)

    Format to whatever colour you choose,

    You did not state a version of excel, so I could not be more specific

    Regards

    Dav

+ 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