Post reply

Highlight cell with red color

  • August 24, 2008 at 7:01 am

    #211496

    Hi all,

    I create cube and I have three measure one of them if be less than specific value should be display with red color, any suggest I will appreciated

    Note: I need it when browse cube in AS

    Thanks in advance

  • August 25, 2008 at 3:23 pm

    #862830

    In the Color property of the textbox that displays the value that should be red when it is below a particular threshhold, put a statement similar to the one below. Note that in this example the value in question is contained in a field called Field1 and the threshhold is 100.

    =IIF(Fields!Field1.Value < 100, "Red", "Black")

    For an even more dramatic effect you can use this same type of statement to alternate the BackgroundColor with Red and Transparent, and then alternate the Color with White and Black.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply