Compare two columns

Hi,

in excel I would like to compare two columns based on rows with different numbers and bold higher value. Adding new columns isn't propriet.

I was thinking about condition formating, but I just can't solve that mistery.

Please Login or Register  to view this content.

Thank you!

Hi,

Try this in conditional formatting. Then use paint brush to format Col B

=A1=MAX(A:A)

VBA Noob

Hi,

The attached will explain Conditional formatting

http://www.contextures.com/xlCondFormat01.html

The paint brush is on your toolbar's at the top of the screen

VBA Noob