View Single Post
  #1   Report Post  
Dave
 
Posts: n/a
Default How to auto number cells that have colour

Hi

I would like to auto number cells that have only a light yellow colour.
In Row C sheet1 I have numbers starting from 0001 etc, some cells in the
column do not have light yellow these remain blank.
So if a Row C cell becomes light yellow i would like the next number to be
added.

Thanks in Advance