Conditional Formatting Greater Than >

[jschoon4]

I have two columns. Column A (Price) Column B (New Price). I want to highlight Column B cells that are Greater Than Column A cells. How is this done?

<tbody>
[TD="class: xl616"] Price[/TD]
[TD="class: xl618"]New Price[/TD]

[TD="class: xl615"]$26.52[/TD]
[TD="class: xl615"]$30.00
[/TD]

[TD="class: xl615"]$80.00[/TD]
[TD="class: xl615"]$80.00[/TD]

[TD="class: xl615"]$80.00[/TD]
[TD="class: xl615"]$80.00[/TD]

[TD="class: xl615"]$80.00[/TD]
[TD="class: xl615"]$80.00[/TD]

[TD="class: xl615"]$195.00[/TD]
[TD="class: xl615"]$200.00[/TD]

[TD="class: xl617"]$370.16[/TD]
[TD="class: xl615"]$390.00[/TD]

</tbody>

 

[Andrew Poulsom]

Select B2:B7 and (with B2 the active cell) apply the Conditional Formatting formula:

=B2>A2

 

[DavideG]

you select conditional formatting based on formula for the column b with formula B1 > A1 this is going to apply format specified to the cells in column B that are bigger then the relative cell in column A

 

[jschoon4]

Thank you very much