Painting equal cells
 

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

Painting equal cells
 

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" wrote in message
...
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

Painting equal cells
 

Thanks Rick,

Worked perfectly,
Amnon
"Rick Rothstein (MVP - VB)" wrote in
message ...
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" wrote in message
...
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