View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andos Andos is offline
external usenet poster
 
Posts: 2
Default Changing a row colour automatically based on a cell input.

Is there a method whereby I can have a input a date in a cell and it will automatically change the row colour? I am tracking a workflow process.

For example,
if I input a date into cell C7, then row 7 would change all cells to be colour 'LIGHT BLUE'.
if I then, input a date into cell D7, then row 7 would change all cells to be colour 'YELLOW'.
if I then, input a date into cell E7, then row 7 would change all cells to be colour 'GREEN'.
etc, etc...

Any ideas on the best way to do this?