Conditional Formatting

=$B$1="Accepted"
format cell yellow

=$B$1="Not Accepted"
fomat cell green

and so on...



"mdavison" wrote:

In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional
formatting to accept my IF statement. Should I be using a different function?

Example
B1 contains Accepted, C1 turns yellow
B1 contains Not Accepted, C1 turns green
B1 contains Cancelled, C1 turns hot pink
possibly others, but that's is the jist.

Thank you!