Format color in cell range

[navacastro]

Hi, i'm new in the forum, and i need a little help with this:

i have a excel file where i do cost control. In the excel worksheet i have the main colums like this

Col A = Date
Col B = Description
Col C = Processing
Col D = Income
Col E = Outcome
Col F = Balance

i need when in a row i change the value of the column C (Processing) to Y, the range of cells of that row from A to F change the back color to green, and when the column C is different from Y remove the green back color.

Could you give the formula or example in excel 2003 and 2007.

Thanks for your time!

PD: Sorry my english.