Column Comparison

[mjbrant0]

https://imgur.com/zQ4OYAs

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.

 

[philwojo]

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:

=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:

=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[>