+ Reply to Thread
Results 1 to 7 of 7

Conditional formatting - empty rows

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    l
    MS-Off Ver
    Excel 2007
    Posts
    5

    Conditional formatting - empty rows

    Hello everyone,

    I'm using excel 2010, and I'm having some problem with conditional formatting. I need to highlight lowest price in each row, which I accomplished with formula =F6=MIN($F6:$J6) in formatting rule, and after that copied that rule with format painter to entire selection. But I have some empty rows, and I would like that they stay without any format. Formula =IF($F6:$J6="", "", MIN($F6:$J6)) doesn't work.
    Can someone help me with formula, I would like to do it automatically, without selecting each empty row and deleting format for specific selection.

    Thanks.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formatting - empty rows

    Hi

    Try this, In Conditional Format rules..

    =AND($F6<>0;F6=MIN($F6:$J6))
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-20-2011
    Location
    l
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Conditional formatting - empty rows

    Thank you for very quick response. I owe you.

    Formula works nicely, but not in each row, because I have rows which are not empty, but don't have value in first column ($F6).

    Condition should be something like $F6:$J6<>0, than use formatting.

  4. #4
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Conditional formatting - empty rows

    Try =AND($F6<>"",F6=MIN($F6:$J6))

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formatting - empty rows

    Try this in F6 and copy down and to the right.

    Thia should works for you..

    =AND($F6<>0;$F6=MIN($F6:$J6))

  6. #6
    Registered User
    Join Date
    01-20-2011
    Location
    l
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Conditional formatting - empty rows

    Works perfectly! I can't thank you both enough.

    I was mistaking for selecting whole row, and then applying it to entire table. Like you wrote, I should create rule for only one cell, and then copy format to whole selection.

    Thanks again.

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional formatting - empty rows

    You are welcome!

    Glad to helped you!

+ 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