Update the row when type at a cell

  • Thread starter Thread starter LSB
  • Start date Start date
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
 
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)
 
You could do that with conditional formatting.

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