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!

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

--
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!

Thank you Jacob!

Now it perfectly works!

"Jacob Skaria" wrote:

> 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
>
> --
> 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!