| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Painting blank cells | Excel Worksheet Functions | |||
| Format painting bars in a chart | Charts and Charting in Excel | |||
| Painting Cells | Excel Discussion (Misc queries) | |||
| Painting Locked Cells | Excel Discussion (Misc queries) | |||
| cell painting | Excel Worksheet Functions | |||
Linear Mode
