Hi I have the following VBA code (see spreadsheet attached), which when run gives the following sentence in cell b10, "Attendance for Palm Beach is 19000, having increased from last year by 20%...."
I am wondering could I alter the code so that percentage figures in the text are highlighted in green when they are above 10%.
Help would be very much appreciated.
Book1.xlsm
Hi Nav,
try it
strange problems with the internet, the code is not inserted
Sorry, there was a glitch yesterday
Edited:
I'll try to attach a file with the code
Last edited by nilem; 08-11-2013 at 01:29 AM.
Try the attached.
Last edited by jindon; 08-10-2013 at 05:55 PM.
same problem as jindon, this is my version
Last edited by patel45; 08-11-2013 at 03:24 AM.
If solved remember to mark Thread as solved
Apply the custom number format [<.1]0%;[green]0% to the cells in question.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks