LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default color changing cells


I have a job tracking spreadsheet that I would like help with. As a job
progresses we X off that
column so we know the status of each box that we are processing. What
I would like to do is
everytime an X is entered into a row I would like that cell to turn a
certain color and once the final "Done"
X is entered I would like the entire row to turn a different color.
That way we knew how far along and
which boxes are finished. Does anyone have a solution they would like
to share?

Thanks in advance


--
darrenm
------------------------------------------------------------------------
darrenm's Profile: http://www.excelforum.com/member.php...o&userid=33880
View this thread: http://www.excelforum.com/showthread...hreadid=536591

 
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
Changing the color of highlighted cells krish Excel Discussion (Misc queries) 1 March 2nd 09 11:05 PM
Changing the color of cells by formula Emerogork Excel Worksheet Functions 1 August 24th 07 12:32 AM
color changing of cells changetires Excel Discussion (Misc queries) 7 June 15th 06 07:43 PM
Changing color on a range of cells Pete Excel Programming 3 December 31st 03 10:03 PM
Changing color of cells Carl Brehm Excel Programming 5 October 31st 03 12:27 PM


All times are GMT +1. The time now is 09:04 PM.

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"