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