ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   changinging the color of sign digit (https://www.excelbanter.com/new-users-excel/131408-changinging-color-sign-digit.html)

JE McGimpsey

changinging the color of sign digit
 
There's no way to do this and keep the entry a number. You *could* use
an event macro to convert the number to text, then format the text, but
the entry would no longer work in math operations.

Post back if you want to pursue that option.


In article ,
"hassan barjini" wrote:

I would like to know how can I change the color of digit
for example if I write the number -12.52 the color of the sign will change
to blue and the rest will change to red.
best
barjini


hassan barjini

changinging the color of sign digit
 
I would like to know how can I change the color of digit
for example if I write the number -12.52 the color of the sign will change
to blue and the rest will change to red.
best
barjini




All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com