I would like to compare prices between columns D and G. I want to create a formula that would make the cell red if its price is lower than the other cell in its row.
I can't view your image while at work, but just highlight the cell you want to turn red and then go to Conditional Formatting (CF) and enter this formula:
Code:
=d1 < g1
<g1[ code]
If you need it in both cells do that for the ones in column D by highlighting all you want to turn red, put int he formula, then change the formatting to what you want.
If you want it for column G also, then use this formula after you highlight all the cells you want in column G:
Code:
=g1 < d1
Just remove the spaces in the formula, the board treats it as html code so the spaces need to be added here to display correctly.<d1[ code]<="" html=""></d1[></g1[>
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.