EXCEL - format cells to make negative numbers red and show them with persian numerals
I'm not familiar with excel formats but I've found these two formats and I need to combine them to have a result of comma separated Persian numbers which negative values are red,
to make negative numbers comma separated and show negative values in red :
#,##0_ ;[Red]-#,##0
to show numbers with Persian/Arabic numerals:
[$-2060000]
any help would be appreciated
Try using conditional formatting as a workaround. Red font when <0.