Trying to highlight cells based on various criteria and the calculate the number
of cells highlighted, have no idea where to begin so here the best example I can give.
if cell G:5-G:200 equal 0
if cell I:5-I:200 contains the text #EANF#
if cell k:5-k:200 contains the text #EANF#
if cell L:5-L:200 contains the text #EANF#
then highlight only the cell ranges C:5-C:200 and D5-D200 that meet all the above criteria in black.
Then I need to a formula in cell N:2 to calcualte the total sum of Blacks highlighted.
Thanks if someone can help.