B
basic
I have a tough and unusual question that I'm not sure can be done.
I have a spreadsheet that has different cells highlighted in two different
colors. I am trying to add up the number of times a highlighted number (of
the two colors) appear in a section.
I am trying to search A1..AS2 , A4..E26, F4..O8.
The two colors to look for are:
Color index= 39 or 4
Pattern= xlsolid
I am looking for a total of highlighted numbers that include both colors.
The numbers I would be searching for are from 1-9 and I would like to find
out how many 1's, 2's, 3's...etc.
Example:
#1= 4 times
#2= 6 times
#3= 0 times
#4= 2 times
I have a spreadsheet that has different cells highlighted in two different
colors. I am trying to add up the number of times a highlighted number (of
the two colors) appear in a section.
I am trying to search A1..AS2 , A4..E26, F4..O8.
The two colors to look for are:
Color index= 39 or 4
Pattern= xlsolid
I am looking for a total of highlighted numbers that include both colors.
The numbers I would be searching for are from 1-9 and I would like to find
out how many 1's, 2's, 3's...etc.
Example:
#1= 4 times
#2= 6 times
#3= 0 times
#4= 2 times