I have Windows XP using Excel 2003 - using a spreadsheet with several several
rows of data - I have them highlighted in yellow if still open- once it is
closed - i put in a date and then manually highlight the row and select no
fill - so then it is white again. Is there a way to have the whole row
change to no fill if I put a date in that row for example I use columns a
through m for the information needed - I put a date in column L when it is
complete. I would like columns a - m for that row go from yellow to white
when a date is entered.