dynamically change the background, foreground colors of a cell based on contents

• Express12

  SSCoach

  Points: 18526

  More actions

  April 2, 2007 at 12:29 pm

  #116831

  I have a report showing SOURCE & TARGET DB rowcounts.  I'd like the cell on the report to have it's background highlighted in RED w/ the text highlighted in WHITE whenever the rowcounts mismatch. 

  Example:

  TABLE1  Source Rowcount=250    Target Rowcount=250

  TABLE2  Source Rowcount=9912  Target Rowcount=0

  TABLE3  Source Rowcount=54    Target Rowcount=54

  Does anyone know how to dynamically change the background, foreground colors of a cell based on contents?

  BT

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  April 2, 2007 at 1:05 pm

  #698163

  You can go to the "Expression" settings in the properties box for each of those and do something like this:

  =IIf(Fields!Source_Rowcount.Value Fields!Target_Rowcount.Value, "Red", "White")