Hello to all,

I got a mystical problem in tracking the bulk of continuous changes made in
a monitoring worksheet.

I need to count the number of cells in a worksheet that contains a specific
color of text.

e.g
In A1 contains text like this "The quick brown fox jumps over the lazy dog."

if the text "lazy dog" is colored red while the others are in black or blue
or whatever,
is it possible to count A1 as part of the cells that has red text in it...by
macro.?

I hope that this is possible, otherwise I am caught in a big mess counting
with my fingers these cells with red text in a group of text along thousands
of cells.

thanks for any advice or suggestion.
--
regards,