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.

[NBVC]

Select all of the range from A1:F (last row)

In 2003:

Go to Format|Conditional Formatting

Select Formula Is from Drop down and enter formula: =$C1="Y"

click Format and choose from Pattern tab.

In 2007:

Go to Home|Conditional Formatting|New Rule

Select "Use a formula to determine which cells to format" from top section

Enter formula: =$C1="Y"

Click Format and choose from Fill tab.

[navacastro]

Thanks for your time NBVC!