Trying to find a solution to see if there is a way to format the numbers in a sentence to the colour red??
Example:
If (A1=100) & (B1=120)
="Today i scored "&text(sum($A$1),"0.00")&" and tomorrow i will try for "&text(sum($B$1),"0.00")
I would like the result to look like this:
Today i scored 100 and tomorrow i will try for 120
Any ideas?
replace D1 with cell you want output
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That is really good thank you. i can put a button in to run the macros. Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks