COUNT THE NUMBER OF CELLS IN A SPREADSHEET CONTAINING RED TEXT

[Guest]

HI, how do i count the number of cells in a excel spreadsheet that contain
red text? is this some form of countif or conditional count function, how do
i search for red text cells?

 

[Frank Kabel]

Hi
you need VBA. See:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm