Nesting IF functions???

So if Duty1 and Duty3 are permitted does that mean the request can be restated as find whether the same name appears in both Duty1 and Duty2?

An example workbook with manually added resulst woud be useful.

Perhaps try a countif() in a Conditional Formatting rule?

Here is the spreadsheet I am working on which shows the Duties and the Individuals Assigned. Notice how Karen is signed up for all three Duties. I need Duty 2 to either strike-through her name or highlight it in red to show that she cannot do all three duties. Notice how City is assigned Duty 1 and Duty 3 I need to highlight in green that this is ok. I am unsure of the formula to do this IF/THEN format. I honestly don't know where to begin, I just know it can be done. HELP!

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use since they don't allow us to test a solution without recreating your workbook which nobody is keen to do.

Seems I have to post this in 2 posts...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula

4. enter =COUNTIF($A7:$S7,"Karen") > 2 format fill as needed.

You will probably need a new rule for each name

What is the answer to the Q I asked in #2?

I am fairly certain this forum can answer your questions.

However, we need you to help us, help you.

Richard asked a question, and I have suggested a formula - can you provide some feedback on those please?