conditional Color formatting

• tebalsamo

  Old Hand

  Points: 348

  More actions

  April 27, 2010 at 12:10 pm

  #234304

  Hi,

  I need to set a field to either red or black dependent on the aggregate value of 2 other fields. e.g.

  if Fields!ActualCost2.Value < Fields!BudgetAmt.Value

  then insert a 3rd field int the textbox Fields!Variance.Value and format it black

  else insert the 3rd field Fields!Variance.Value and format it red

  How should I do this?

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  April 27, 2010 at 1:15 pm

  #1158449

  If you go back and reread the article the section titled: Applying basic conditional formatting tells you exactly what you need to do.