| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to color automatically color code sums in cells
I have been using MS Excel for years now, but my new job requires a little
more indepth knowledge which I really hope some of you can assist me with cause I really don't want to have to ask the boss. Right now I am trying to take a value from a cell and have it automatically color code the font, ex. a1:a2:b1:b2 value of 0=red, 1-50=black, 51-100=blue etc. if any of you can help me out I would greatly appreciate it. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to color automatically color code sums in cells
You can get up to 6 colors using this technique:
http://www.mcgimpsey.com/excel/conditional6.html Otherwise, you'll need to use an event macro. In article , kuroitenpi wrote: I have been using MS Excel for years now, but my new job requires a little more indepth knowledge which I really hope some of you can assist me with cause I really don't want to have to ask the boss. Right now I am trying to take a value from a cell and have it automatically color code the font, ex. a1:a2:b1:b2 value of 0=red, 1-50=black, 51-100=blue etc. if any of you can help me out I would greatly appreciate it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Need a formula that sums a column but could exclude some cells | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
