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

  • Thread starter Thread starter conditional formatting one question
  • Start date Start date
C

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.
 
How to program VBA to realize it, please help me to do it.
Regards
 
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
 
Back
Top