Conditional formatting microsoft excel mac 2011

It is a bit convoluted, but works well once you follow these steps. We welcome your comments and questions about this lesson.

Use Conditional Formatting to shade alternate rows in Excel

We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam.

Office 2011 for Mac All-in-One For Dummies

I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. Add a comment to this lesson. I want to commend people like you who take the time to post such excellent instructions for people like me. You hard work does not go unappreciated! Alma Grace. I agree. These instructions were clear and complete.

You've provided excellent instructions.


  • velveeta salsa mac n cheese recipe;
  • Question Info!
  • windows vs linux vs mac 2015.

Thanks for taking the time and effort to share them. Greatly appreciated.

Search form

Thank you, just want I needed for the Mac, kept getting PC instructions You would think Microsoft would just make this a one click option I seem to get an error message onc ei enter this function any insights? I'm really grateful for this lesson. Thanks so much for taking the time to explain this process. Hi Cru. Thanks for pointing that out. I'll update the lesson to include both options. Much clearer than the Microsoft help! I've been looking for an easy way to do this for years!

Thank you so much for the simple and clear instructions - MUCH appreciated! This helped me out a lot!

ms office - Stop Excel for Mac () continuing formatting from last cell entered? - Ask Different

Thank you so much! Cheers, M. Skip to main content. Search form Search. So unfortunately the answer is that this is not possible with Mac Excel , but is possible in Windows using the standard Conditional Formatting features. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Home Questions Tags Users Unanswered. In Mac Excel , how to format cell as percentage or currency based on content of another cell? Ask Question. For instance: A B bids 0. Jonathan van Clute. Jonathan van Clute Jonathan van Clute 4 StartupSpreadsheets StartupSpreadsheets 46 4. So how would I go about doing what you describe, since using a formula would destroy the data in column B?

I don't need to determine what the current formatting is, since the format is determined solely by the text in column A. I still can't think of any way to get column B to format the cell based on the value in column A.

Excel: Conditional Formatting

Add the formulas to column C, referencing column B, and hide column B. Another trick I like using is coloring the font white so it looks hidden, but just remember that it's there so you don't overwrite it: I'm still not following. I manually add rows in column B many times every day, so that column can't be hidden, and I still don't see how I can format that column conditionally as either currency, general, or percentage depending on the content in column A. Adding another column that displays the value of column B depending on the text in column A, is no help because I have to input the values in column B anyway so Or am I completely misunderstanding your suggestion?

OK, keeping adding your data to B, but add this formula to C1 and copy down: Yeah but that's exactly what I don't want


  • MS Excel for Mac: Change the font color based on the value in the cell.
  • Office 2011 for Mac: Choosing Conditional Formatting Rules in Excel.
  • demolition company free download mac!
  • RELATED ARTICLES.