Conditionally Formatting Cell Background and/or Font Colors

[BestMark 0]

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).

 

[labrashjw 0]

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