Jim,

Here is one way using conditional formatting.

Select all the cells in the column (I am assuming column A).
Goto to FormatConditional Formatting
Set Condition 1 to Formula Is
Add this formula
=AND(ROW(A1)<=MATCH("",$A$1:$A$100,0),ROW(A1)=MA TCH("<",$A$1:$A$100,0))
Click format, and set a pattern colour
OK out

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"jim" wrote in message
m...
I have an excel spreadsheet that I have to update every month. This
involves laboriously highlighting all text between the characters "<"
and "" in one particular column. Is it possible to write a macro
that will make my life easier?! I'm new to this so all pointers would
be really appreciated.

MTIA

Jim