Conditional Formatting

S

streetboarder

I would like some help on the following:

Months and Quarters across the top.
Projected Volume (B14) = 5,000
Actual Volume (B15) =
% Variance =IF(B15>0,B15/B14-1,"")
Forecasted Staff (B17) = Set number
Required Staff =IF(B15>0,B17*B16+B17,"")

The forumla's seem to be working correctly. What I would like to do
know is put a conditional format on the Variance row. If Variance is
plus or minus 10% than highlight so it sticks out during a fast review.
If Variance is zero or 9% either way leave as is.

Addtionaly, I want to add a conditional format to the Required Staff
row. If Staff equals plus or minus .1 FTE (Full Time Employee) than
format accordinaly if .09 than leave alone.

Also, if I could add a final row to say "Staffing level is "over or
short" (depending on the result) needs review" that would be great
too.

Thanks,
Josh
 
B

bmorganh

The first thing is to use an if/or statment in the cell which says that if
the variance is either greater than 10% or less than 10% that the value is
shown in the cell. If the statement is false i.e., the values of the
variance is within the +/- 10% window then the cell is left blank "". Then
you format the cell using a conditional formating formal that if the cell is
not equal to nothing perform the bold bright highlighting you desire.
 
S

streetboarder

Any chance you can show me one formula and I can figure out the other
one from there. I now know how to use If Statements but haven't used an
If/or before.

Thanks,
Josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top