| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula do I use? Using 2007
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! -- Lydia |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What formula do I use? Using 2007
see your other post
-- Biff Microsoft Excel MVP "Lydia" wrote in message ... 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! -- Lydia |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What formula do I use? Using 2007
Try the same formulas given in the previous post
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse 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 --------------- Jacob Skaria "Lydia" wrote: 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! -- Lydia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Formula and VBA help | Excel Discussion (Misc queries) | |||
| Formula help in Excel 2007 | Excel Worksheet Functions | |||
| I need a formula for excel 2007 | Excel Discussion (Misc queries) | |||
| Get Label formula with get.formula(selection()) in XL-2007 | Charts and Charting in Excel | |||
| 2007 formula help please | Excel Discussion (Misc queries) | |||
Hybrid Mode
