Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXcel problem
As an example I have a estimated monetary value in cell B4 and in cell C4 I
have the actual cost. I have set up the spreadsheet to show in cell F4:- if the value is lower in cell C4 then the text in cell F4 is set to 'OK' if the value is higher then the text is set to 'over budget. I wish to change the text colour in F4 to red if the item is 'Over Budget' and blue if a returned value is OK. Thank you for any help Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXcel problem
You have to do this in 2 stages:
First, type this formula in F4: =IF(C4<=B4,"OK","Over Budget") That will get you the text in F4. Second, with F4 selected, click on Format | Conditional Formatting and choose Formula Is rather than Cell Value Is in the first box of the pop-up. Use this formula: =C4<=B4 then click on the Format button, click on the Color drop-down and choose blue. Click OK, followed by Add to set up your second condition. This time you need Formula Is with this formula: =C4B4 then click Format, Color and choose red. Click OK twice to exit the dialogue box. That should do you. If you want the same set-up for cells below F4, then just copy the cell down and the cell references (and Conditional formatting) will adjust automatically. Hope this helps. Pete On Feb 6, 4:27*pm, MicrosoftBob wrote: As an example I have a estimated monetary value in cell B4 and in cell C4 I have the actual cost. *I have set up the spreadsheet to show in cell F4:- if the value is lower in cell C4 then the text in cell F4 is set to 'OK' if the value is higher then the text is set to 'over budget. *I wish to change the text colour in F4 to red if the item is 'Over Budget' and blue if a returned value is OK. Thank you for any help Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXcel problem
Hi,
To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =F4="OK" 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Formula is 10. In the second box enter the formula: =F4="Over Budget" 11. Click the Format button 1. Choose a color and click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, Manage Rules, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: same formulas as above 5. Click the Format button and choose a format. 6. Click OK twice 7. New Rule 8. Choose Use a formula to determine which cell to format 9. In the Format values where this formula is true enter the following formula: same formula as in 2003 10. Click the Format button and choose a format. 11. Click OK tree times.-- If this helps, please click the Yes button Cheers, Shane Devenshire "MicrosoftBob" wrote: As an example I have a estimated monetary value in cell B4 and in cell C4 I have the actual cost. I have set up the spreadsheet to show in cell F4:- if the value is lower in cell C4 then the text in cell F4 is set to 'OK' if the value is higher then the text is set to 'over budget. I wish to change the text colour in F4 to red if the item is 'Over Budget' and blue if a returned value is OK. Thank you for any help Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |