Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting matching cells in two different worksheets
Worksheet 1 consists of a single column containing the first 1000
prime numbers. Worksheet 2 consists of multiple columns of numbers. Is there a way to highlight with a chosen fill color all cells in worksheet 2 containing prime numbers from worksheet 1? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Cells on different worksheets | Excel Discussion (Misc queries) | |||
Highlighting non-matching ZIP in a batch | Excel Discussion (Misc queries) | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
finding matching cells in worksheets | Excel Worksheet Functions |