color the Text box as per the value

[newssis]

Hi all,

I would like to know if i would be able to fill the color in text box as the value of column.

Such as

I have 4 text box in line. each from 1-25, 2nd 26-50, 3rd 51-75, and 4th 76 -100 range. I want to color the text box as if the value is 24% then color the text box 1 with red.. and if the value is 29% then color the textbox 1 till 25 and text box 2 with 4 more and show the value?

Is it possible? if so how?

Please guide!!

Thanks
Pat

 

[jymm]

I might be doing this the hard way, but this seems to work for me. My crietera is a bit differnt, but I am sure you can change this. I wanted it red when the projected we could make was greater than the amount we had on order... remembering how IIF works other than how I would expect...

SO - on the properties for the text box - go to the color propery and select 'Expression'

=IIF(Fields!Projected.Value-Fields!OnOrder.Value < 0, "Red", "Black")

this help or hinder?

 

[xlbo]

That's the way to do it!

Would do something like

TB1:

=iif(Fields!FieldName.Value <= 0.25,"Red","White")

TB2:

=iif(Fields!FieldName.Value > 0.25 AND Fields!FieldName.Value <= 0.5,"Red","White")

etc etc for TB3 & 4

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question