What formula do I use? Using 2007

  • Thread starter Thread starter Lydia
  • Start date Start date
L

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!
 
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
 
Back
Top