Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
I am looking for a fomula or macro that will change the formattion of a cell
based on the result. Example: If the actual revenue is 90% or less of the budgeted revenue then change the cell color to red. If the actual revenue is 105% or more of the budgeted revenue then change the cell color to blue. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
Look at Conditional Formatting. It is under Format in the menu.
You have two methods of choosing the basis for the conditional - actual value of the cell itself, or a formula that can evaluate the value of yet another cell. You may have up to 3 conditions set to change the format of the cell, so that gives you 4 format options (doesn't meet any of the criteria, plus meets 1 of the other 3). If your percentage is in the formula you're wanting to change colors on, you can use Cell Value Is and greater than or equal to 1.05 and set color Blue for one condition and set another for less than or equal to .9 and set color to red. "Rich Stanek" wrote: I am looking for a fomula or macro that will change the formattion of a cell based on the result. Example: If the actual revenue is 90% or less of the budgeted revenue then change the cell color to red. If the actual revenue is 105% or more of the budgeted revenue then change the cell color to blue. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
In the format pull down there is conditional formating. "Rich Stanek" wrote: I am looking for a fomula or macro that will change the formattion of a cell based on the result. Example: If the actual revenue is 90% or less of the budgeted revenue then change the cell color to red. If the actual revenue is 105% or more of the budgeted revenue then change the cell color to blue. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
It sounds like you just need to use conditional formatting
(\Format\Conditional Formatting). You can have up to 3 conditions with different formats (plus a fourth, if you count the original - i.e. no special conditions met). Will "Rich Stanek" wrote: I am looking for a fomula or macro that will change the formattion of a cell based on the result. Example: If the actual revenue is 90% or less of the budgeted revenue then change the cell color to red. If the actual revenue is 105% or more of the budgeted revenue then change the cell color to blue. Any ideas? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
You want conditional formatting, which is accessible via the Format menu.
For the first condition, enter the formula =A1<=B1*.9 then format red For the second condition, enter the formula = A1=B1*1.05 then format blue This assumes that the budgeted revenue is in B1 and A1 has actual revenue. Adjust the formulas above to suit how your spreadsheet is designed. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Rich Stanek" wrote: I am looking for a fomula or macro that will change the formattion of a cell based on the result. Example: If the actual revenue is 90% or less of the budgeted revenue then change the cell color to red. If the actual revenue is 105% or more of the budgeted revenue then change the cell color to blue. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
formatting a cell the same as the source cell from a lookup table | Excel Discussion (Misc queries) | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |