Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary based on highlighted cells
I have asked this before, but got no answer - just more questions. I have
modified my request. I need to create a macro to add the following numbers in cell A based on highlighted cells in that row: Add 17 in cell A if cell G is highlighted Add 10 in cell A for each cell from H thru P that is highlighted Add 1 in cell A for each cell from Q thru AA that is highlighted Add 11 in cell A if cell AB is highlighted Add 1 in cell A for each cell from AC thru AE that is highlighted I need to do this for every row of my spreadsheet. By highlight I mean any color except for white (no color). This macro should be executed by me whenever all updates are in and I need totals. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows Based on highlighted Color | Excel Discussion (Misc queries) | |||
PivotTables - Calculations based on generated summary data | Excel Discussion (Misc queries) | |||
Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
Summary Based on Multiple Criteria | Excel Worksheet Functions | |||
Create summary based on specifc value in a different sheet | Excel Worksheet Functions |