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

  • Thread starter Thread starter Renata
  • Start date Start date
R

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!
 
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
 
Thank you Jacob!

Now it perfectly works!

Jacob Skaria said:
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
Click to expand...
 
Back
Top