Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating on column matches
Select column A to bottom of range.
FormatCFFormula is: =A1=B1 Format to Yellow Pattern and OK Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 10:26:00 -0800, Mikey B wrote: I have what I thought was a simple idea but after reading these boards I have yet to figure a way to make this work. I would appreciate any help. I have a sheet with 20,000 records. I want to check each field in column A with each field adjacent to it in column B and have the results show a highlight in column A if it matches column B. example: A1,A2, A7 should be highlighted (yellow) A B 1. 111 111 2. 222 222 3. 333 4. 444 333 5. 555 333 6. 777 666 7. 777 777 8. 777 888 Thanks again for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating - by row, not by column (Office 2007) | Excel Discussion (Misc queries) | |||
Conditional Formating if Greater Than or Less Than other column | Excel Worksheet Functions | |||
Use conditional formating to find one word in a column. | Excel Discussion (Misc queries) | |||
Macro row and column conditional formating problem | Excel Programming | |||
Conditional formating 1 column based on another? | Excel Programming |