Several Excel Questions

**Rick5955** · 01-19-2014, 05:48 PM

Hello,

I have a few Excel questions. Thank you in advance for your help.

1. Is is possible to have two different and unrelated formulas apply to the same cell? I have a spreadsheet that monitors when someone is signed up for a class, and the cell with the formula counts the number of blank spaces remaining (COUNTBLANK), and reports the number of blank spaces in the cell. I would also like to add a second formula, that will turn the cell's background color to RED, when the number of available blank cells reaches zero. Is this possible? If so, can you offer a suggestion as to what the formula for changing the background color might look like?

2. For a few of the classes tracked on my spreadsheet, there are only a few spaces to sign up in. This makes the spreadsheet very short vertically, and very long horizontally. Is there a way to print the cells that the sign ups are entered into, so that the cells can be fit sequentially onto an 8 1/2 by 11 sheet of paper, instead of printing the entire row of cells, from left to right?

Thanks for your help.

Rick5955

**shg** · 01-19-2014, 06:40 PM

1. Conditional formatting; see http://www.contextures.com/xlCondFormat01.html

2. No, there isn't. You need to arrange the worksheet as you wish it to print.

**arlu1201** · 01-20-2014, 01:08 AM

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.