Conditional Formatting (Or possibly IF condition)

Hi Erica

Sorry for the delay, lots of meetings for me today!

Try this formula I've drafted for you (see attached file):

=SUMIF(column B cell range, B#, column C cell range)>1

First part - What range do you want to check, in this case the names of people (e.g. $B$4:$B$13).

Second part - Set your criteria, so make it column B (where your names are) and the row of which persons name you want to match (e.g. B4).

Third part - When there is a match, add the total values from column C for all the matched results.

Fourth part - Looks for if total value more than 1. 

How this works

1. Highlight the column you want the conditional format to go in (e.g. I have used column B but I can also do column C or both B&C).

2. Go to the Home menu tab, drop down the list for Conditional Formatting.

3. Go to New Rule... and select Use a formula to determine which cells to format.

4. Enter the formula into the text box (e.g. =SUMIF($B$4:$B$13, B4, $C$4:$C$13)>1). 

5. Click onto the Format button and choose what formatting you want.

6. Click OK to save your changes. Your cells should light up in your desired format when the total value for a person listed in column B is more than 1. If they are less than one the text will go to normal formatting.

File is attached. You'll see the format change when you play with the numbers in column C.

I hope I have understood you right and that this is what you were after. Let us know how you go?

Cheers

Damien