Gridline & amount convert

[TQ]

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 !

 

[Alan]

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