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>