Painting equal cells


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
 
Ad

Advertisements

R

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
 
Ad

Advertisements

A

Amnon Wilensky

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell painting 2
Equal Cells 2
Cell Equality 5
Painting blank cells 4
Cells equal a number 3
Sum equal cells 2
equals merged cells 2
paint cells with highest numbers 2

Top