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) |