I have a column with positive and negative values..i need to give colours for them green for positive numbers and red for negative number..i m doing this report in rdlc..plz suggest how can i acheive the desire report...

I have a column with positive and negative values..i need to give colours for them green for positive numbers and red for negative number..i m doing this report in rdlc..plz suggest how can i acheive the desire report... Select the column textbox and the background color expression for that textbox would be =IIF(Fields!FieldName.value>0,"Green",Red") HTH Rajkumar Yelugu

Hi Rajkumar, I am trying to do the same - colour text in a cell depending on whether positive or negative. The catch is that it is from a pull down menu that has already been established. So if I choose a -1 to -5 from the pulldown list, I want these values to appear in red. If they choose +1 to +5, these should be coloured green. Stems from my original issue: when I have created the pulldown menu from my list (via data/validation), it has not carried across the original formatting. - nicole