Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2016, 09:56 AM
RAH RAH is offline Coditional formating percentage of figure Windows 10 Coditional formating percentage of figure Office 2016
Advanced Beginner
Coditional formating percentage of figure
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default Coditional formating percentage of figure


I have a cell D3 which displays 2000kg and I have another cell D11 which displays a sum from a formula using the 2000kg I would like the cell D11 to change colour if it is =to or less than ten percent of the total of cell D3 I have entered the formula =D11<0.1*D3 it presently changes to red constantly what am I doing wrong
Reply With Quote
  #2  
Old 07-10-2016, 11:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Coditional formating percentage of figure Windows 7 64bit Coditional formating percentage of figure Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Could you post a small sample sheet please? - Click Go Advanced - Manage attachments
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-10-2016, 11:39 AM
RAH RAH is offline Coditional formating percentage of figure Windows 10 Coditional formating percentage of figure Office 2016
Advanced Beginner
Coditional formating percentage of figure
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default Coditional formatting a percentage of cel value

Please find attached spread sheet I have posted a previous matter surrounding this spread sheet regarding displaying the highest tension value automatically
Attached Files
File Type: xlsm Drifting loads .xlsm (187.0 KB, 18 views)
Reply With Quote
  #4  
Old 07-11-2016, 12:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Coditional formating percentage of figure Windows 7 64bit Coditional formating percentage of figure Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your problem is probably due to the fact that you are using merged cells. These are known to cause more trouble than they are worth.

Unmerge the cells and try again. If needed for cosmetic reasons You can always reformat with horizontal alignment - Center across selection and Vertical alignment - Center
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 07-11-2016, 05:22 AM
xor xor is offline Coditional formating percentage of figure Windows 10 Coditional formating percentage of figure Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
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

Try in an empty cell to enter =D1.

I 100% agree with Pecoflyer on merged cells.
If it was up to me Merge & Center should be forbidden.
Reply With Quote
  #6  
Old 07-16-2016, 04:43 AM
RAH RAH is offline Coditional formating percentage of figure Windows 10 Coditional formating percentage of figure Office 2016
Advanced Beginner
Coditional formating percentage of figure
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

Thank you very much problem solved silly me Oh and how do you mark post as solved
Reply With Quote
  #7  
Old 07-16-2016, 09:14 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Coditional formating percentage of figure Windows 7 64bit Coditional formating percentage of figure Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Click "Thread tools" ad select "...solved" (the FAQ contains lots of information)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #8  
Old 07-16-2016, 11:04 AM
RAH RAH is offline Coditional formating percentage of figure Windows 10 Coditional formating percentage of figure Office 2016
Advanced Beginner
Coditional formating percentage of figure
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

Thread tools only gives the option unsubscribe or printable version
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Formating with ChartTitle Font and DataLabel Formating shilabrow Excel Programming 0 06-30-2014 10:01 AM
Caption Order: Figure 4 Figure 3 Figure 2 golfarchitect13 Word 5 05-07-2014 07:15 PM
Coditional formating percentage of figure Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc. altjx Word 4 06-04-2013 05:29 AM
Coditional formating percentage of figure overall percentage ketanco Project 1 08-04-2012 05:56 AM
Coditional formating percentage of figure formating a percentage in a Mail Merge dkalsow Mail Merge 3 04-03-2012 03:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 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