Compare two columns
 

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.

Compare two columns
 

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.

"Kaizen10" wrote:

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.

Compare two columns
 

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

HTH
--
AP

"Kaizen10" a écrit dans le message de
oups.com...
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.