View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SLKoelker SLKoelker is offline
external usenet poster
 
Posts: 19
Default Automatic color fill

I have a spreadsheet with over 1400 line entries. I am marking them with an
'x' in the 'complete' column when I have completed that line but it's getting
to be harder to read because of the amount of data. I was wondering if there
is any way to make the box and/or line change to a certain color (i.e. green
or blue) when I mark my 'complete' column with an 'x'. Please help.