conditional formatting

• bencantello

  SSC Rookie

  Points: 26

  More actions

  April 2, 2008 at 4:35 pm

  #184035

  hey there I have a series of finacial reports. the girls that work on them want color and the boss wants them to print in black and white. the color back grounds print grayscale so I would like to add a link of some sort that changed the background to transparent when they want to print a report.

• toolman-352714

  SSCrazy

  Points: 2495

  More actions

  April 3, 2008 at 11:13 am

  #797968

  The only way I can think of to do that is to add a "Print Version" parameter. You can then set the backgrounds based on the parameter value.

  =IIF(Parameters!Print.Value = "Print", "Transparent", "Yellow")

  HTH

  [font="Comic Sans MS"]toolman[/font]
  [font="Arial Narrow"]Numbers 6:24-26[/font]