View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
darrenm darrenm is offline
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