What formula do I use? Using 2007

[Lydia]

I want a symbol or color to appear when I have the following words entered
into a cell (failed, pass, pending and offer made). I'm thinking I need an IF
formula or conditional formatting, but I've never used either. I would rate
myself as a 5 on Excel on a 1-10 scale. I'm no expert!

Thanks for all the help!

 

[T. Valko]

see your other post

 

[Jacob Skaria]

Try the same formulas given in the previous post

Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter the formula in the box below:
Click the Format button
Select the desired style(s)
OK out

If this post helps click Yes