Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

«September 2015»
MonTueWedThuFriSatSun
311

Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT

image

I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my session Power Pivot 101: An Introduction to the PASS Excel BI Virtual Chapter! For a lot of users, Power Pivot is like the Ferrari you had in your garage but weren’t aware and that’s one of the reasons I’m so excited to be able to present on this topic. This session is completely free and available to all who would like to attend. It doesn’t get much better than that!

Register for free Power Pivot training

Power Pivot is a powerful yet flexible analytics tool built into a familiar environment yet many users remain unsure of how to take advantage of this dynamic tool. In this session, we’ll discuss the purpose of Power Pivot, where Power Pivot fits within your organization and the basics of designing a Power Pivot model that integrates disparate data sources with the goal of gaining previously unrecognized insight into key business metrics.

This free online training event is scheduled for Thursday September 10th at 12 pm CST/1 pm EST. If you’re interested in attending, all you need to do is RSVP here to let the organizers know you’re coming. It’s going to be a great event, a lot of fun and maybe even educational! ;)


Read more
23456
78910111213
14151617181920
21222324252627
2829301234
567891011

Conditional formatting using multiple conditions - Excel 2007

  • 3 March 2011
  • Author: indupriya
  • Number of views: 94743
  • 0 Comments

Today I had a requirement to colour code in Excel based on a few conditions.  At first I thouhgt I could use thre to four rules in the conditional formatting to achieve this result but when I did that the results that I was getting was not very satisfactory.  So I thought I would try the And function of excel in conjunction with the conditional formatting and it worked wonders.

I wanted the entire row to be highlighted in a certain colour based on three conditions.

Here are the steps I followed to achieve what I was after.

  • Select all the data that you want to colour code.
  • Click on Conditional Formating on the Home Tab
  • Choose Manage Rules as shown below

Manage Rules

  • From the dialog that appears click New Rule
  • Add the multiple conditions using the And function in the formula box.
  • The most important thing you need to do when you are adding the formula to highlight rows is to remove the $ sign that gets assigned when you choose the cell for entering a formula with a mouse.
  • Choose the colour by clicking the format button and click ok
  • Click Ok again to come out of the Manage Rules window.
  • As you can see below I have added two rules and it is giving me the result that I want.

 

formula

 

This trick I am sure can be used in the Business Intelligence world when your interface is Excel.

 

 

 

Print
Categories: Blogs
Tags:
Rate this article:
5.0

indupriyaindupriya

Other posts by indupriya

Please login or register to post comments.