| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format: % of total
Hi Not sure if this can be done, I just can't work it out at this point.
Scenario: A1: $10000 B1: $ 7500 (this is has a sum total) How to I colour B1 when it reaches 25% of A1? TIA Bec |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format: % of total
Select B1.
Conditional formattingFormula Is enter below formula and select a color (if equal) =B1=A1*0.25 (if more than 25%) =B1A1*0.25 If this post helps click Yes --------------- Jacob Skaria "AussieBec" wrote: Hi Not sure if this can be done, I just can't work it out at this point. Scenario: A1: $10000 B1: $ 7500 (this is has a sum total) How to I colour B1 when it reaches 25% of A1? TIA Bec |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format: % of total
Thanks Jacob, it was easier than I thought. What if there was a different
figures in each cell. Would I need to set individual conditions or could I use an if statement. A1: 1000 b1:500 A2: 800 b2: 400 A3: 70 B3:60 "Jacob Skaria" wrote: Select B1. Conditional formattingFormula Is enter below formula and select a color (if equal) =B1=A1*0.25 (if more than 25%) =B1A1*0.25 If this post helps click Yes --------------- Jacob Skaria "AussieBec" wrote: Hi Not sure if this can be done, I just can't work it out at this point. Scenario: A1: $10000 B1: $ 7500 (this is has a sum total) How to I colour B1 when it reaches 25% of A1? TIA Bec |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format: % of total
Sorry, just worked it out. Remove absolute value.
"AussieBec" wrote: Thanks Jacob, it was easier than I thought. What if there was a different figures in each cell. Would I need to set individual conditions or could I use an if statement. A1: 1000 b1:500 A2: 800 b2: 400 A3: 70 B3:60 "Jacob Skaria" wrote: Select B1. Conditional formattingFormula Is enter below formula and select a color (if equal) =B1=A1*0.25 (if more than 25%) =B1A1*0.25 If this post helps click Yes --------------- Jacob Skaria "AussieBec" wrote: Hi Not sure if this can be done, I just can't work it out at this point. Scenario: A1: $10000 B1: $ 7500 (this is has a sum total) How to I colour B1 when it reaches 25% of A1? TIA Bec |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Format: % of total
Happy to hear it worked.
If this post helps click Yes --------------- Jacob Skaria "AussieBec" wrote: Sorry, just worked it out. Remove absolute value. "AussieBec" wrote: Thanks Jacob, it was easier than I thought. What if there was a different figures in each cell. Would I need to set individual conditions or could I use an if statement. A1: 1000 b1:500 A2: 800 b2: 400 A3: 70 B3:60 "Jacob Skaria" wrote: Select B1. Conditional formattingFormula Is enter below formula and select a color (if equal) =B1=A1*0.25 (if more than 25%) =B1A1*0.25 If this post helps click Yes --------------- Jacob Skaria "AussieBec" wrote: Hi Not sure if this can be done, I just can't work it out at this point. Scenario: A1: $10000 B1: $ 7500 (this is has a sum total) How to I colour B1 when it reaches 25% of A1? TIA Bec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to conditional format the Sub Total Table ? | Excel Discussion (Misc queries) | |||
| Excel total format | Excel Worksheet Functions | |||
| Conditional Total in a Cell | Excel Discussion (Misc queries) | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
Linear Mode
