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.
T-SQL Tuesday #73 Invitation – Naughty or Nice?
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.
This trick I am sure can be used in the Business Intelligence world when your interface is Excel.
Other posts by indupriya