Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Is it possible to set a conditional format in a worksheet so that when I copy
work from MS Project it automatically removes the trailing space and "h"? I use MS Office 2003. Thanks for your help. Johnnie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Conditional formatting is for highlighting cells based on its contents.
You can strip traliling spaces by using TRIM function and h by using RIGHT, LEFT or MID function, as appropriate. "Johnnie" wrote: Is it possible to set a conditional format in a worksheet so that when I copy work from MS Project it automatically removes the trailing space and "h"? I use MS Office 2003. Thanks for your help. Johnnie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Sheeloo,
Thanks for the info. Johnnie "Sheeloo" wrote: Conditional formatting is for highlighting cells based on its contents. You can strip traliling spaces by using TRIM function and h by using RIGHT, LEFT or MID function, as appropriate. "Johnnie" wrote: Is it possible to set a conditional format in a worksheet so that when I copy work from MS Project it automatically removes the trailing space and "h"? I use MS Office 2003. Thanks for your help. Johnnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |