Please help!
i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out.
I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the cells in the 3rd Column ("R") if they appear in all 3 Columns. When he asked me i thought of course! But when I went to do it, I realized "Duplicates" wouldn't work. Spoke with a friend of my told me "IF" function should work but did not have time to get into it.
this may be easy but any help would be a life saver!!!!!
"H" "M" "R"
<colgroup><col><col><col></colgroup><tbody>
</tbody>
i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out.
I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the cells in the 3rd Column ("R") if they appear in all 3 Columns. When he asked me i thought of course! But when I went to do it, I realized "Duplicates" wouldn't work. Spoke with a friend of my told me "IF" function should work but did not have time to get into it.
this may be easy but any help would be a life saver!!!!!
"H" "M" "R"
01-1-1-Q | 01-143-2-Q | 1-37-1-Q |
01-1-2-A | 01-143-4-A | 01-11-1-Q |
01-174-2-Q | 01-165-2-Q | 1-54-1-Q |
01-44-4-Q | 01-190-4-Q | 4-31-1-L |
01-49-0-Q | 01-195-4-Q | 03-92-0-C |
01-49-3-Q | 01-200-2-Q | 03-69-10-Q |
01-5-1-Q | 01-200-4-Q | 03-96-1-L |
01-64-1-Q | 01-235-01-A | 2-82-2-Q |
01-64-6-Q | 01-235-0-Q | 01-64-1-Q |
01-74-2-Q | 01-238-2-Q | 01-64-6-Q |
01-84-4-Q | 01-241-0-Q | 1-69-1-Q |
01-9-0-Q | 01-245-7-Q | 1-92-2-Q |
01-9-2-Q | 01-44-4-Q | 2-44-0-Q |
02-104-2-Q | 01-49-0-Q | 2-44-4-Q |
02-34-4-L | 01-49-3-Q | 2-47-0-Q |
02-34-5-L | 01-64-1-Q | 2-84-4-Q |
02-37-1-L | 01-84-4-Q | 2-88-4-Q |
02-37-3-L | 02-104-4-A | 2-93-2-Q |
02-44-01-L | 02-130-2-A | 2-96-7-Q |
02-44-0-Q | 02-133-2-Q | 2-98-5-Q |
02-44-2-L | 02-143-2-Q | 2-103-1-A |
<colgroup><col><col><col></colgroup><tbody>
</tbody>