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

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

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

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

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