Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I would like some help on the following: Months and Quarters across the top. Projected Volume (B14) = 5,000 Actual Volume (B15) = % Variance =IF(B150,B15/B14-1,"") Forecasted Staff (B17) = Set number Required Staff =IF(B150,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 -- streetboarder ------------------------------------------------------------------------ streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707 View this thread: http://www.excelforum.com/showthread...hreadid=505537 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
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. "streetboarder" wrote: I would like some help on the following: Months and Quarters across the top. Projected Volume (B14) = 5,000 Actual Volume (B15) = % Variance =IF(B150,B15/B14-1,"") Forecasted Staff (B17) = Set number Required Staff =IF(B150,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 -- streetboarder ------------------------------------------------------------------------ streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707 View this thread: http://www.excelforum.com/showthread...hreadid=505537 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
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 -- streetboarder ------------------------------------------------------------------------ streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707 View this thread: http://www.excelforum.com/showthread...hreadid=505537 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |