Help! Conditional formatting or "if"

[ttop1010]

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"

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>

 

[ttop1010]

ok i removed the Conditional Formatting and it seems to be working...how should i got about using the re-applying the Conditional Formatting without disturbing your rule?


thanks again Joe

 

[Joe4]

When you apply multiple Conditional Formatting Rules, you can order them in the precedence that you want them.

After you have applied multiple rules to a certain range, select that range, click on Conditional Formatting menu and select "Manage Rules".
There, you can click on the Up/Down arrows to put them in any order you want, and can check the "Stop If True" check box.