| 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. |
| 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 | |||
Threaded Mode
