Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2022, 12:34 PM
Cosmo Cosmo is offline Custom Format not working on cells with formula Windows Vista Custom Format not working on cells with formula Office 2007
Competent Performer
Custom Format not working on cells with formula
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default Custom Format not working on cells with formula

I"m a bit rusty in Excel, so this may be a simple issue.

I need to apply a Custom Format to a column with a formula. The formatting works if the cell has a value entered into it, but if it uses a formula (even as simple as just 'A1'), the format doesn't work.



Is there something I'm missing that will allow me to apply a custom format to a cell that has a formula?

Edit: I have fixed my issue with brute-force by doing all of the formatting within the formula (it's now a pretty long formula, but it works), and I may keep this solution, but I would like to know if there's a reason why I can't apply a custom format to a formula.
Reply With Quote
  #2  
Old 11-01-2022, 03:36 AM
Debaser's Avatar
Debaser Debaser is offline Custom Format not working on cells with formula Windows 10 Custom Format not working on cells with formula Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

You can apply a custom format to a formula (though 'A1' is not a formula) result, though it will apply to the entire result, not simply parts of it.

What is the formula and what custom format are you trying to use?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom format Manikandan Excel 1 06-23-2022 02:30 AM
Custom Style Sets Stopped Working on Custom Template after Recent Microsoft Update CynthiaKPollard Word 6 12-20-2021 08:37 PM
Custom Format not working on cells with formula Conditional formatting formula to format cells not equal to a group value Marcia Excel 2 11-02-2019 06:15 AM
Custom Format not working on cells with formula How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Custom Format not working on cells with formula Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:50 PM.


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