Update the row when type at a cell

L

LSB

Hi Experts out there,

I would like to seek for your help. I am trying to write
some codes that will update the entire row color when
certain word is type in a particular cell.

For Example, I am using Column A as the status check.
WHen I type "Done" in the the cell A2, then I want the
entire row 2 to be highlighted in grey.

How do I go about doing this?

MANY THANKS IN ADVANCE...

LSB
 
B

Bob Phillips

I think conditional formatting will do this.


Select all the rows
Goto menu format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$A2="Done"
Click Format
Select the Patterens tab, choose the colour
OK
OK


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

You could do that with conditional formatting.

In Excel, select the row.
Format menu - Conditional formatting
Formula is: =$A2="Done"
choose a format etc
 
Top