Hi guys 1ce again i m stuck somewhere, i have a cell (c1) containing simple formula like (a1*b1) i want the value to be displayed as for eg : 35.66* but my problem is i want only * to be in red color, i tried #,##0.00"*" to add * to my value but i am unable to give red color to the *, can anyone pls suggest some solution. Thanks in advance.
Regards,
Little Master
Regards,
Little Master
Try This ...........
[Red]0.00 "*";[Red]0.00 "*"
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
thnx mubashir, but it didn't worked....
I am fairly sure it can't be done using the 'Format | cells...' menu.
It may be possible to do something via a macro but unfortunately I am not a macro specialist.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
its pretty simple ..... select C1 now go in format>Cell>Number>Custom> in TYPE bar paste the code ......
[Red]0.00 "*";[Red]0.00 "*"
Mubashir, it doesn't work. Your suggestion is causing the entire cell to turn red. The Op wants this:
35.66*
...just the star in red.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks