Conditional Formatting

J

Johnnie

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
 
S

Sheeloo

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.
 
J

Johnnie

Sheeloo,
Thanks for the info.
Johnnie

Sheeloo said:
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.
Click to expand...
 
Top