Conditional Formatting - multiple criteria

Select cells C3 to C10, then click on Conditional Formatting | New Rule | Use a Formula ...

Then put this formula in the box:

=C3=VLOOKUP("O",$A$3:$C$10,3,0)

then click on the Format button, and in the Font tab use the drop-down for Color and choose red. Then OK your way out.

Hope this helps.

Pete

Awesome! Thanks

Thx for your help. One follow up question to my original....

What if COL A had multiple "O" - how can that work?
In this case....the MARK/TINA 9's would be highlighted and also the MIKE/JUDY 6's would be highlighted

x - Mike - 6
x - John - 5
o - Mark - 9
x - Stan - 3
x - Tina - 9
o - Judy - 6
x - Jeff - 1
x - Bill - 3

See attached file.

I've put this array* formula in E1 to find the largest value in column C where column A contains "o":

=LARGE(IF($A$1:$A$8="o",$C$1:$C$8),ROWS($1:1))

and then copied this into E2 to find the next largest value. You can copy this down further if you have other values, but delete any #NUM errors that might occur if you copy it too far.

Then I highlighted cells A1:C8 and clicked on Conditional Formatting | New Rule | Use a formula, and then put this formula in the box:

=ISNUMBER(MATCH($C1,$E:$E,0))

and then clicked the Format button and chose a Red fill. You can see all 3 adjacent cells are highlighted, as requested.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <Enter>.

Hope this helps.

Pete