conditional formating for the whole row, based on one cell value

[Renata]

I have applied conditional formating to cell G6, when I choose value "Closed"
from drop down menu for this cell, it gets huighlighted in grey. I would like
the range A6:J6 to get highlighted in grey as well. How do I apply this part
in Excel-2003?
Thank you!

 

[Jacob Skaria]

1. Select the cell/Range (say A6:J6)

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=$G6="Closed"

4. Click Format Button>Pattern and select your color (say Grey)

5. Hit OK

 

[Renata]

Thank you Jacob!

Now it perfectly works!

1. Select the cell/Range (say A6:J6)

2. From menu Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=$G6="Closed"

4. Click Format Button>Pattern and select your color (say Grey)

5. Hit OK