Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-02-2018, 03:12 PM
xor xor is offline Excel Custom Formatting Conditions Windows 10 Excel Custom Formatting Conditions Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Select the cell(s) to format, Conditional Formatting, New Rule, Use a formula to determine which cells to Format. In the New Formatting Rule dialog in the field Format values where this formula is true, you write:

=$A$1>9999999999999

Press Format. In the Format cells dialog select the Number tab. Under Category select Custom and in the field Type, write "("###")" ###-#### ####. OK you out. Then in the Conditional Formatting Rules Manager press New Rule and repeat the process with next condition ($A$1>999999999999) and so on. Be aware that Excel cannot handle more than 15 digits as numbers.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Custom Formatting Conditions Conditional Formatting if certain cell meet certain conditions bbutl027 Excel 1 11-25-2016 12:52 AM
Excel Custom Formatting Conditions Looping through word and writing to excel when certain conditions are met Irene H Word VBA 2 07-10-2016 05:59 PM
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
Excel-Save Custom Formatting CarlaK Excel 1 10-18-2013 05:05 PM
Embedded Excel Graphs - Custom Formatting Cody Drawing and Graphics 0 07-02-2010 02:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 AM.


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