| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total values per colour
Hi,
I have a number of rows, for each row I have several columns Red Green Blue Pink Row1 | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 |Total1 |Total2 |Total3 |Total4 Row2 | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 |Total1 |Total2 |Total3 |Total4 Row3 | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 |Total1 |Total2 |Total3 |Total4 Row4 | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 |Total1 |Total2 |Total3 |Total4 For each col1 - col7 there will be a value which will be colour coded, I would like to be able total the values in the Total columns for the correct colours - is this possible? Regards, Sanj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change font colour for values. eg if value < 10 red, gre. | Excel Discussion (Misc queries) | |||
| Sum total cells to change colour | Excel Discussion (Misc queries) | |||
| Change text colour if range of values all zero | Excel Worksheet Functions | |||
| How can I colour format all cells based on their values | Excel Worksheet Functions | |||
| Having colour for different values | Excel Discussion (Misc queries) | |||
![Sanjay[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
