In SSRS 2008 R2 I have a report with a bunch of columns evenly spaced 3 columns apart. I want to set some conditional formatting so that if the date in column 6 is before the date in column 3 the cell turns red. ...and if the date in column 9 is before the date in column 6 it turns red, etc. for about 16 date fields.
If the current cell can be referenced by "me.value" how would I reference the field -3 columns from "me?"
I want to turn this:
=IIF(Me.Value > 2, "red", "green")
into something like:
=IIF(Me.Value < Me(-3).Value "red", "green")
So that I can just past the same expression in the Fill area of all the columns without having to reference each field by name.