Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-21-2022, 07:19 AM
Manikandan Manikandan is offline Custom format Windows 10 Custom format Office 2021
Custom format
Join Date: Jun 2022
Posts: 1
Manikandan is on a distinguished road
Default Custom format

I want compact number(k or Million or Billion) with color as "red" for negative number
For example

1) It should support negative number with paratheses ex: (#)
2) Negative number color should support.
3) It should support positive and negative numbers with compact format.


Reply With Quote
Old 06-23-2022, 02:30 AM
Debaser's Avatar
Debaser Debaser is offline Custom format Windows 7 64bit Custom format Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Posts: 188
Debaser is on a distinguished road

You can't do all of that with a custom number format. You would need to use conditional formatting rules (or code) to apply different formats.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom format Custom format 4 digit number to 0:00 Marcia Excel 5 06-05-2021 11:06 PM
Custom Date Format - MM/YYYY ProjectUser Project 0 10-28-2019 03:21 PM
Custom format Custom format a merge field paul h Mail Merge 2 09-09-2015 07:18 AM
Custom format Creating a custom number format bremen22 Excel 2 01-16-2014 07:23 AM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft