You can use Conditional Formatting, say in A1:

Formula Is:

=LEFT(A1,2)="T "

and then set your desired formats
--
Gary''s Student - gsnu200750


"Pman" wrote:

Hi guys,

I have multiple columns of data in which there are many occurences of a
certain object. These values start with "T" and then there's a space and then
a code/ date [looks something like T APR01/07, or T 09102007].

I was wondering if someone could help me with a macro that changes the font
color for the columns between H and AG for cells starting with T and space,
and change the color of the values to teal (plus bold it). I tried
conditional formatting, but it doesn't have anything for cells beginning with
a certain value.

Thanks,

Pman.