| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting format properties when opening Worksheet
Hello, I'm going to push data into existing excel file from Access. Once
there I want to format it based on text in the cell. For example, here's some sample of the text in each cell: Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Setting format properties when opening Worksheet
You can use either conditional formatting or a macro.
-- Gary's Student "Don" wrote: Hello, I'm going to push data into existing excel file from Access. Once there I want to format it based on text in the cell. For example, here's some sample of the text in each cell: Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 Cell 1 = Henry Smith *1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating worksheet without opening | Excel Discussion (Misc queries) | |||
| Color format cells based on list in seperate worksheet | Excel Worksheet Functions | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| How can I format a worksheet to carry out all calculations to 2 d. | Excel Discussion (Misc queries) | |||
Linear Mode
