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

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!

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

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

2. From menu FormatConditional Formatting

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

4. Click Format ButtonPattern and select your color (say Grey)

5. Hit OK

--
Jacob


"Renata" wrote:

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!

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

Thank you Jacob!

Now it perfectly works!

"Jacob Skaria" wrote:

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

2. From menu FormatConditional Formatting

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

4. Click Format ButtonPattern and select your color (say Grey)

5. Hit OK

--
Jacob


"Renata" wrote:

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!