How do you format a cell if the data in the cell contains 1 of several buyers
out of a greater list of buyers.

One column in my spreadsheet contains the buyer for that row. I would like
to format that cell if certain buyers are entered.

eg.
Buyer - column heading
a
b
a
d
c
d

I would like to format the cell that contain a and d. I tried to use "Or"
function. such as OR(C53="a", C53="d") but it did not work.


I have excel 2007.

Thanks