Gridline & amount convert
 

Hi, can excel do as below ?

1. show certain/part gridline only in worksheet.If yes,how about show with
colour ?

2.For example A3=USD540.00,is that possible that A5 will automatic show in
amount that is FIVE HUNDRED FORTY ONLY ?

Thanks !

Gridline & amount convert
 

In answer to 1. use borders rather than grid lines and you can specify
any lines you want in any colour you want.

in answer to 2. have a look at http://xl.barasch.com/cCo11432.htm