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"[TABLE="width: 343"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]01-1-1-Q[/TD]
[TD]01-143-2-Q[/TD]
[TD]1-37-1-Q[/TD]
[/TR]
[TR]
[TD]01-1-2-A[/TD]
[TD]01-143-4-A[/TD]
[TD]01-11-1-Q[/TD]
[/TR]
[TR]
[TD]01-174-2-Q[/TD]
[TD]01-165-2-Q[/TD]
[TD]1-54-1-Q[/TD]
[/TR]
[TR]
[TD]01-44-4-Q[/TD]
[TD]01-190-4-Q[/TD]
[TD]4-31-1-L[/TD]
[/TR]
[TR]
[TD]01-49-0-Q[/TD]
[TD]01-195-4-Q[/TD]
[TD]03-92-0-C[/TD]
[/TR]
[TR]
[TD]01-49-3-Q[/TD]
[TD]01-200-2-Q[/TD]
[TD]03-69-10-Q[/TD]
[/TR]
[TR]
[TD]01-5-1-Q[/TD]
[TD]01-200-4-Q[/TD]
[TD]03-96-1-L[/TD]
[/TR]
[TR]
[TD]01-64-1-Q[/TD]
[TD]01-235-01-A[/TD]
[TD]2-82-2-Q[/TD]
[/TR]
[TR]
[TD]01-64-6-Q[/TD]
[TD]01-235-0-Q[/TD]
[TD]01-64-1-Q[/TD]
[/TR]
[TR]
[TD]01-74-2-Q[/TD]
[TD]01-238-2-Q[/TD]
[TD]01-64-6-Q[/TD]
[/TR]
[TR]
[TD]01-84-4-Q[/TD]
[TD]01-241-0-Q[/TD]
[TD]1-69-1-Q[/TD]
[/TR]
[TR]
[TD]01-9-0-Q[/TD]
[TD]01-245-7-Q[/TD]
[TD]1-92-2-Q[/TD]
[/TR]
[TR]
[TD]01-9-2-Q[/TD]
[TD]01-44-4-Q[/TD]
[TD]2-44-0-Q[/TD]
[/TR]
[TR]
[TD]02-104-2-Q[/TD]
[TD]01-49-0-Q[/TD]
[TD]2-44-4-Q[/TD]
[/TR]
[TR]
[TD]02-34-4-L[/TD]
[TD]01-49-3-Q[/TD]
[TD]2-47-0-Q[/TD]
[/TR]
[TR]
[TD]02-34-5-L[/TD]
[TD]01-64-1-Q[/TD]
[TD]2-84-4-Q[/TD]
[/TR]
[TR]
[TD]02-37-1-L[/TD]
[TD]01-84-4-Q[/TD]
[TD]2-88-4-Q[/TD]
[/TR]
[TR]
[TD]02-37-3-L[/TD]
[TD]02-104-4-A[/TD]
[TD]2-93-2-Q[/TD]
[/TR]
[TR]
[TD]02-44-01-L[/TD]
[TD]02-130-2-A[/TD]
[TD]2-96-7-Q[/TD]
[/TR]
[TR]
[TD]02-44-0-Q[/TD]
[TD]02-133-2-Q[/TD]
[TD]2-98-5-Q[/TD]
[/TR]
[TR]
[TD]02-44-2-L[/TD]
[TD]02-143-2-Q[/TD]
[TD]2-103-1-A[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.