+ Reply to Thread
Results 1 to 3 of 3

Conditional format 3 columns some with 0's

  1. #1
    Registered User
    Join Date
    11-18-2003
    Posts
    19

    Conditional format 3 columns some with 0's

    Hi,
    I hope you can help me. I have 3 columns. I want to conditional format the lowest price of 3. I can do that but if a column is zero and the other 2 columns have values in them nothing gets highlighted. Also, if 2 columns have the same value and their value is lower than the 3rd, nothing gets highlighted either.
    Please help!!!
    Thanks!
    Lori

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I couldn't find an efficient way to not highlight duplicates, but in order to highlight the lowest number in a row of 3 columns, try this conditional format

    =MIN($A$1:$C$1)=C1

    Hopefully, someone can help you with the other part of your problem

  3. #3
    Registered User
    Join Date
    11-18-2003
    Posts
    19

    Conditional format 3 columns some with 0's

    Thanks for your help!

+ 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