in

Software FX Community

Discuss and find help for all Software FX products.

Conditionally Formatting Cell Background and/or Font Colors

Last post 01-15-2010 4:15 PM by labrashjw. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-18-2009 11:04 AM

    Conditionally Formatting Cell Background and/or Font Colors

    Is there a way to conditionally format the background color and/or font color in a cell? 

    For example....

    - when the cell value is negative, the cell background color is red (white font color)

    - when the cell value is positive, the cell background color is green (white font color)

    - when the value is 0, the cell background color is white, (black font color).

     

  • 01-15-2010 4:15 PM In reply to

    Re: Conditionally Formatting Cell Background and/or Font Colors

    Look under

    FormattingDataValue

    then look at e.field.datapath and e.datavalue the you can use

    String.Format("<span style=""color:red"">{0}</span>", e.FormattedValue)

     Hope that helps

Page 1 of 1 (2 items)
Copyright 2008 Software FX, Inc.