Sometimes we want to emphasize cells based on their values. That way data analysis becomes easier because we combine best of charts and tables we still see the values while we have additional color information about the value in each cell.
A typical case is highlighting the background of cells with green or red color for good or bad results, respectively. It's a pretty trivial operation in Excel and it's not that hard in MDX either. This recipe demonstrates how to do this.
Open BIDS and verify you have the Gross Profit formatted measure defined in the previous recipe, Setting special format for negative, zero and null values. If not, define the measure like this:
Create Member CurrentCube.[Measures].[Gross ...