I have a 3.1 GHz Intel Core i5 Mac running OS# X v10.8.2. I am using Excell for

Question

I have a 3.1 GHz Intel Core i5 Mac running OS# X v10.8.2. I am using Excell for Mac 2011 Home and Student version 14.2.5. Here's the problem: the controls for text alignment and text wrap have no effect in a cell that has been conditionally formatted. No matter how the text was aligned and/or wrapped prior to application of conditional formatting, the text always appears at the bottom of the ceell, left justified, and not wrapped. The status of the formatting controls in the tool bar may be showing otherwise, but the text always appears unwrapped, at the bottom of the cell, and left justified. I would be most gratteful for instruction on how to control text alignment and text wrap in a cell that has been conditionally formatted.

Explanation / Answer

Well, that certainly is not my experience. wrapped text and vertical alignment stay as they were originally set before the conditional format was applied. Also that formatting does not change whether the formatting conditions are mett or not. Please eexplain EXACTLY what you are doing, what the formatting conditions aare, and what format you have selected if the conditions are met. based on your descriptions, I can not verify your problem and it looks like conditional formatting is working properly.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.