Multi-Coloured Comments & Increasing Font SiZe of a particular Line for Highlighting.

Multi-Coloured Comments & Increasing Font SiZe of a particular Line for Highlighting..

Dear Forum,

I am dynamically adding Comments to two cells in particular the Cells J8 and J68..

The Text in the Cell J8 is as shown:



The Last Transaction of the Previous Financial Year :
i.e. 01-Apr-08 till 31-Mar-09 was on 28-Mar-09 and the
Opening Balance on this day was :
Rs 56,569.69



As can be seen after Formatting that the entire text is BOLDENED


Line 1 -> The Last Transaction of the Previous Financial Year : is in DarkRed Font
Line 2 -> i.e. 01-Apr-08 till 31-Mar-09 is in Royal Blue &
Line 2 -> was on & and the is again in DarkRed Font.
Line 2 -> 28-Mar-09 is in Red Font
Line 3 -> Opening Balance on this day was : Green Font

Line 4 -> Rs 56,569.69 is in Dark Green Font only this last line to have Font Size 14



This would HIghLight the Text in the COmment plus it would also emphasize on the Opening Balance Amount.

Need the same thing to be replicated in the cell J68 with slightly different text.



The Last Transaction of the Current Financial Year :
i.e. 01-Apr-09 till 31-Mar-10 was on 14-Mar-10 and the
Opening Balance on this day was :
Rs 17,019.69



This text is dynamically got from the different cells incase if thats important to be informed..



Warm Regards
e4excel