Apply Green color for positive and Red for negative numbers #shorts

preview_player
Показать описание
Apply Green color for positive and Red for negative numbers

[Green]#,###,[Red]-#,###;0;

Related searches
excel conditional formatting green positive red negative
how to make negative numbers red in excel
how to make negative numbers red in google sheets
a conditional format can make negative numbers red and positive numbers black.
negative red color
highlight same positive and negative numbers in excel
how to make positive numbers green in excel

#Excel #Excel_Tricks #shorts
Рекомендации по теме
Комментарии
Автор

Hello, Does this code use the "conditional formatting"? I am avoiding conditional formatting because it bugged up my spreadsheet so badly I had to start it again. It looks like it doesn't.

chunkymonkey
Автор

Can I do this from an ipad? I can’t seem to find the conditional formatting function from my ipad… 😢

agent-htri
Автор

Tried it too, but highlighted a group. Didnt work for me either

paulae
Автор

फार्मूला तो अच्छा है लेकिन रेड कलर के बाद दशमलव के बाद की संख्या नहीं दिखता दशमलव के बाद की संख्या दिखाने के लिए क्या फॉर्मूला लगेगा

sharemarketanalysis
Автор

how do I removed red characters from a cell?

vanessarodriguez
Автор

Koi asa formula btaan k -456 is tarha ki value auto zero show ho

khantech