Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total red Total Blue need help from you
Hello
I have conditional formatting =$$AA5="Red" format is highlight in red, second conditional format is =$$AA5="Blue" format is highlight in blue. I want to total all the cells in column D,that are highlighted in red and the result to go in cell N1 then Total all the cells in column D that are highlighted in blue and the result to go in cell N2 the column range is always A toZ and the total number of rows depends on the report rows Can someone , please help me with a macro. Thank so much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |