Painting equal cells

[Amnon Wilensky]

Hi,
I have to columns, side by side full with 248 rows of data.
How can I paint, using conditional formatting, the cells with equal data?

Thanks,

Amnon

 

[Rick Rothstein \(MVP - VB\)]

Select both columns of data (here I'm assuming these are Column A and Column
B at Row 1), select "Formula Is" in the Conditional Formatting dialog box
and use this formula...

=AND($A1=$B1,A1<>"")

Rick

 

[Amnon Wilensky]

Thanks Rick,

Worked perfectly,
Amnon

Select both columns of data (here I'm assuming these are Column A and
Column B at Row 1), select "Formula Is" in the Conditional Formatting
dialog box and use this formula...

=AND($A1=$B1,A1<>"")

Rick