CODEWITHSUNDEEP
google-sheets-formula
Code Guy
Code Guy

Reputation: 3198

NUmber formatting to display green and red in Google sheets

I have a custom number formatting where I need to change the numbers from black for postive and red for negative

I have the format as: [$₹][>9999999]##\,##\,##\,##0.00;[$₹][>99999]##\,##\,##0.00;[$₹]##,##0.00;

The formatting is used to displaying lakh and crore number systems. I only need to display the colors.

Upvotes: 0

Views: 457

Answers (1)

kishkin
kishkin

Reputation: 5325

Like this?

[$₹][green]##,##0.00;[$₹][red]##,##0.00;[$₹]##,##0.00;

enter image description here enter image description here

Not sure about >999... conditions, you do not mention those.

Upvotes: 3

Related Questions