You can only do what you want with VBA, however, you will need to be
able to check against a test to see if the data is new, this will
probably have to be done using the date.

conditional formatting one question;320811 Wrote:
All,
I make conditional formatting for cells ,which I want them to show
different
collors .
the data for formatting source from another cells in the row1 from same
sheet,
each month ,I need to update the data source and apply to other row to
show
collors. Now I want to make the previous row collors unchanged in
previous
months ,and start another row cells to show collors with May. how to
make it
happen? supposted only updated the data source in the same rows .please
kindly help.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=89686