example:I have a cell that has the column total in it called "TOTALALLO"  If the total is greater than the value in the "ALLOTEDOCIE" cell then I want the cell to turn red, and if it is less than I want it to trun green.Thanks again allSSG_Slair

I am trying to change a cell in a tables color based on the value calculated into that field.  Right now I have the cell running a totals column.Example:  if value is less than 170 turn cell green                if value is greater than 170 turn cell Red.Any assistance would be GREATLY appreciated. ...