Compare two columns

K

Kaizen10

Hi,

I am a basic user and don't know advanced funtions.

Want to compare column A and Column B. Highlight the cell with some
color if any data is same in both the columns.

Any help is appreciated.
 
W

widman

Depending on what I'm doing, I often have a column with the differences.
one column might be "ideal product margin", the other "actual product margin",
I use conditional formatting to either highlight the actual that is too low,
or the difference colum red for low, green for high, black for normal. not
real advanced, but super usefull.
 
A

Ardus Petus

Select all cells in column A
Menu Format>Conditional format
Select Formula is
Enter =COUNTIF(B:B;A1)>0
Select the format you like
Click OK

HTH
 
Top