Results 1 to 8 of 8

conditional formatting three columns or more

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    CA.
    MS-Off Ver
    Excel 2010
    Posts
    3

    conditional formatting three columns or more

    Hi, I am new to using conditional formatting and just installed excel 2010 and want to take advantage of this ability. However I can not figure out how to compare 3 cells and format based off contents. I have attached a real simple example probelm. I am applying this to compare bid results from numerous vendors.

    I would like to apply the color yellow when a cell contains the lowest value compared to the other 2 cells in its row. Next apply green fill to cells who are second lowest value in the row.

    How would the rules change as the number of values to compare increases? i.e. comparing 5 values across 1 row.

    Thanks for the help
    Attached Files Attached Files
    Last edited by awinchester; 08-11-2010 at 12:34 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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