LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
LSB LSB is offline
external usenet poster
 
Posts: 8
Default Update the row when type at a cell

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation lists update orginal cell with list update [email protected] Excel Worksheet Functions 3 July 11th 08 07:56 AM
Type in one cell and data copies into another cell slavenp Excel Discussion (Misc queries) 2 August 23rd 07 04:02 PM
Type 3 digits in one cell then automatically move to next cell. mulligbo Excel Discussion (Misc queries) 4 October 27th 06 11:51 PM
type MI in cell, have Michigan show in adjacent cell shark Excel Discussion (Misc queries) 2 October 20th 06 07:57 AM
Type into one cell and automatically clear contents in another cell Bo Excel Programming 4 September 29th 03 06:04 PM


All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"