Conditonal Formatting 2 Columns

[pwright]

This is my first post to this site. I'm looking for some help regarding conditional formatting an Excel SS. I am using Excel 2011. The problem that I am having is that I'd like to format the 2 columns so that the higher price gets highlighted, but different colors in each column. Meaning that if the left column has the higher price, the cell will fill in the color blue. If the right column is higher, the cell will fill in the color red. The issue that I have been having is that I can do it for each individual horizontal row, but I can not format both columns, only one row at a time. Currently I can make it work for one row at a time. When I try to extend that formula/formatting for all of the cells in that column, the value that the cell will compare to is always the cell at the top of the other column, not the cell next to the cell I'm trying to compare.

Can anyone help me format this document? Any help will be much appreciated. I've attached the SS I'm attempting to format. The main goal with this SS is to highlight the higher price in a row, but using different colors for each column.

[Harribone]

Conditional Formatting.xlsx

Attached file has three sheets to do three highlighting choices (wasn't 100% sure which you wanted)

Sheet 1 Highlights Red/Blue on each row the highest
Sheet 2 Highlights the highest value out of both columns (i.e. just the one value)
Sheet 3 Highlights the highest value in Col A and the highest value in Col B

[FDibbins]

Hi and welcome to the forum

To do what you want to do is a 2-step process...
1. highlight the range you want to apply the conditional formatting to (A2:A100)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2>B2 format fill as required

Then repeat the above for column B but change the formula to =B2>A2

[pwright]

The first sheet is exactly what I was looking for. I see that the formula for the formatting has "each row" in it. How do I make that formula? Thanks for the quick and excellent response!

[pwright]

Thanks again, this information is perfect!

[newdoverman]

Select column A. Click on Conditional Formatting, New Rule, Use A Formula to Determine....

Enter this formula in the formula field:

Please Login or Register  to view this content.

Click on Format and choose the Fill tab and select the blue colour that you want. Click OK.

Select column B. Click on Conditional Formatting, New Rule, Use A Formula to Determine ...

Enter this formula in the formula field:

Please Login or Register  to view this content.

Click on Format and choose the Fill tab and select the red colour that you want. Click OK.

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[pwright]

I did thank the responders and added to their reputation. I also marked the thread as "solved" Thanks to all for the help!