Highlighting Current Month Column in Cross-Tab Report

[selton]

I have a cross-tab report that contains the month, team name, and counts of issues for each month:

Jan Feb Mar etc.
team1 3 35 0
team2 10 7 19

If the current month is February, I want to change the background of those cells to be "highlighted". I tried using the highlight expert, but can't figure out how to tell it to highlight if Month(CurrentDate) is equal to the Month(data)

 

[bdreed35]

The higlighting expert only lets you deal with numeric values in v8.5. I think in v9 they changed that.

In 8.5, you need to conditionally format the background color. Right CLick, Format Field, and then enter your formula in the X+2 button next to background under the border tab.

Its not Boolean, so you have to tell it what color you want if the condition is met. There are color constants in the Formula editor or you can make your own using the Color function. It is also a good idea to set the else condition and set the color to "crNoColor" when your condition is not met.

~Brian