View Single Post
 
Old 08-27-2019, 09:06 PM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

I was wondering what you meant by negative.

You will have to add a custom format. If you want red font if negative and ()'s, and one decimal place.

#,##0.0%;[Red](#,##0.0%)
Reply With Quote