|
|
#1
07-10-2016, 09:56 AM
|
|||
|
|||
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
 
|
|
|
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 |
 Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc.
|
altjx | Word | 4 | 06-04-2013 05:29 AM |
|
overall percentage
|
ketanco | Project | 1 | 08-04-2012 05:56 AM |
|
formating a percentage in a Mail Merge
|
dkalsow | Mail Merge | 3 | 04-03-2012 03:38 PM |
Windows 10 
Office 2016
Threaded Mode