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

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.

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

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

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

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

"Simon Lloyd" wrote:


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

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

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.

conditional formatting one question;320912 Wrote:
How to program VBA to realize it, please help me to do it.
Regards

"Simon Lloyd" wrote:


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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'How to make cells collor unchange if data source
change in format - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=89686)




--
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

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

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" wrote:


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.

conditional formatting one question;320912 Wrote:
How to program VBA to realize it, please help me to do it.
Regards

"Simon Lloyd" wrote:


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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'How to make cells collor unchange if data source
change in format - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=89686)




--
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

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

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. :)

conditional formatting one question;320960 Wrote:
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" wrote:


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.

conditional formatting one question;320912 Wrote:
How to program VBA to realize it, please help me to do it.
Regards

"Simon Lloyd" wrote:


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' ('The Code Cage' ('http://www.thecodecage.com'
(http://www.thecodecage.com/)))


------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile:
Simon
Lloyd' ('http://www.thecodecage.com/forumz/member.php?userid=1'
(http://www.thecodecage.com/forumz/member.php?userid=1))
View this thread: 'How to make cells collor unchange if data
source
change in format - The Code Cage Forums'
('http://www.thecodecage.com/forumz/showthread.php?t=89686'
(http://www.thecodecage.com/forumz/sh...d.php?t=89686))




--
Simon Lloyd

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

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




--
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