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.