Formula Questions...

[Steven Sinclair]

I have two questions...

1. Is it possible to have a COUNTIF (or something similar) only count cells
containing words with RED text?

2. Is it possible to make a CONCATENATE function echo multiple lines?

Instead of the result being:
The Total Is = 456

Have the result be:
The
Total
Is
456

Thanx.

 

[Gary''s Student]

For color counting, see:
http://www.cpearson.com/excel/colors.aspx

For multi-lines:

="The" & CHAR(10) & "Total" & CHAR(10) & "Is" & CHAR(10) & 456

and format the cell with alignment wrap.