Painting equal cells

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
A

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
 
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
 
Thanks Rick,

Worked perfectly,
Amnon
Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top