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

Select the range and go to Home tab and select Conditional Formatting|Manage Rules.

Click New Rule and select use formula to determine which cells to format from top area:

Enter formula:

=A1=SMALL($A1:$C1,3) and click Format and choose Red from Fill tab (this is for 3rd smallest).

Click Ok... Click New Rule and repeat above with formula:

=A1=SMALL($A1:$C1,2) and apply green for second smallest and repeat again with

=A1=SMALL($A1:$C1,1) and apply yellow for smallest.

Which columns are we talking about?

See attached.

I selected H2 to K11 and applied the conditional formats.

You may need to change the colour scheme to what you desire.

G56709 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.