| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting-Comparing Two Columns
Simple but I can't remember how to do this. I have two lists that I want to compare. If any of the jobs listed in the "closed" section match any jobs in the "Open" section the I want them to be highlighted in the "Closed" section. The colums are sorted ascendingly but as you see by the "CMAS5016" highlighted in yellow they are not right next to each other. They may be a few rows off. Open Closed CMAS5005 CMAS5005 CMAS5007 CMAS5006 CMAS5008 CMAS5011 CMAS5010 CMAS5015 CMAS5013 CMAS5016 CMAS5014 CMAS5018 CMAS5016 CMAS5022 CMAS5019 CMAS5023 CMAS5020 CMAS5028 CMAS5021 CMMT5033 CMAS5025 CMMT5034 CMAS5026 CMMT5052 CMAS5027 CMMT5053 CMAS5029 CMMT5055 CMAS5030 EPSO5005 CMAS5031 FEEM5001 CMAS5032 FEEM5002 Thanks in advance! I tried searching previuos threads but I could not find what I needed. -- Tom K ------------------------------------------------------------------------ Tom K's Profile: http://www.excelforum.com/member.php...o&userid=12124 View this thread: http://www.excelforum.com/showthread...hreadid=538968 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
