| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Not get cell to accept any format change! Source from html | Excel Worksheet Functions | |||
| Copy Source Cells to Destination Cells Only when a Change Occurs | Excel Discussion (Misc queries) | |||
| Format Cells Date (or any change) not working on imported data | Excel Discussion (Misc queries) | |||
| how do I change the fill collor os a cell using a function in VB | Excel Discussion (Misc queries) | |||
| i change a source and the other cells wont change | Excel Worksheet Functions | |||
Hybrid Mode
