Reference Cell Value Without Explicit Reference

• robshobs

  SSC Eights!

  Points: 961

  More actions

  February 2, 2009 at 8:39 pm

  #199706

  I am working on setting some "conditional formatting" for various cells in a report. I cannot figure out how to reference the cell value without having to type an explicit name.

  I can reference the field value using: Fields!MyData.Value

  Or I can reference the cell value using: ReportItems!TextBox1.Value

  All I want to do is reference "Value". This would make setting up the formatting a lot easier as I could select all relevant cells and create an expression something like:

  =SWITH(VALUE = "Yes", "Pink", "No", "Yellow")

  Is there a simple way to do this? Or do I have to code each cell individually?

  Rob

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  February 17, 2009 at 6:36 am

  #945135

  Hello Rob

  As far as I know there is no method available to create a "standard" conditional format based on a Cell value, because the concept of cell value just doesn't exist.

  You have to do it for each one I'm afraid.

  Regards,

  Nigel.

  Nigel West
  UK

• robshobs

  SSC Eights!

  Points: 961

  More actions

  February 17, 2009 at 8:18 am

  #945229

  nigel.c.west (2/17/2009)

  ---

  As far as I know there is no method available to create a "standard" conditional format based on a Cell value, because the concept of cell value just doesn't exist.

  That's what I was afraid of. And did.

  Thank you for the response.

  Rob