February 2, 2009 at 8:39 pm
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
February 17, 2009 at 6:36 am
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
February 17, 2009 at 8:18 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply