Post reply

Format Cell based on conditions in SSRS VS2010

  • March 7, 2014 at 7:29 pm

    #283079

    Hello,

    Struggling to write a Iif or Switch statement in the expression for the following:

    If the cell value is "Y" then nothing

    If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.

    Thank you.

  • March 7, 2014 at 10:03 pm

    #1695289

    Struggling to write a Iif or Switch statement in the expression for the following:

    If the cell value is "Y" then nothing

    If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.

    IIF(Column="y",Nothing,IIF(DATEDIFF("d",TODAY(),[SV3Date])<10,"Red","Black"))

    ??

  • March 11, 2014 at 4:35 pm

    #1696179

    Thank you very much. I was able to take this hint and fix my problem. This can be closed now. Thanks again ..!

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

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