How to make cells collor unchange if data source change in format

[conditional formatting one question]

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]

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.

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)

 

[conditional formatting one question]

How to program VBA to realize it, please help me to do it.
Regards

 

[Simon Lloyd]

I can help but i need more information, will your data on each row be
set to a date or will the date appear in that row?, how is your data
layed out from month to month.....etc, you would be better off supplying
a sample workbook.

How to program VBA to realize it, please help me to do it.
Regards


Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
change in format - The Code Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=89686)

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[conditional formatting one question]

for example :
We have conditional formatting for Apr. component helth :

1: Green :Inv.>Demand +SS *60%
2. White : Inv<Demand
3. Yellow: Demand<=Inv. <=Demand+SS *60%

SS(Apr.) is in the row 2 ,component helth (Apr.) is in the row 3.
Because each month we have different Safety stock level as benchmark ,now
the Month of May is coming ,SS for May has been fixed ,we should updated
row2 to
May SS. and component helth( May) is in the row 4, but when I updated row2
,row 3 will have to be updated automatically ,due to conditional formatting,
but I want the row3 unchange ,how to do it? please do me a favor.
Thanks

 

[Simon Lloyd]

At this point i really need to see a sample workbook
*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so.

for example :
We have conditional formatting for Apr. component helth :

1: Green :Inv.>Demand +SS *60%
2. White : Inv<Demand
3. Yellow: Demand<=Inv. <=Demand+SS *60%

SS(Apr.) is in the row 2 ,component helth (Apr.) is in the row 3.
Because each month we have different Safety stock level as benchmark
,now
the Month of May is coming ,SS for May has been fixed ,we should
updated
row2 to
May SS. and component helth( May) is in the row 4, but when I updated
row2
,row 3 will have to be updated automatically ,due to conditional
formatting,
but I want the row3 unchange ,how to do it? please do me a favor.
Thanks

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)