Turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

"Annette" wrote in message
...
But how would I write this into a macro or write the macro for this?

"Tom Ogilvy" wrote in message
...
Use conditional formatting.

Set up your formula to look at the entry in column A

Select column C,D,E with C1 as the active cell

Under format=Conditional formatting change Cell Value is to Formula is
using the dropdown. In the text box put in the formula

=$A1="frog"

then click format and choose the formatting you want.

--
Regards,
Tom Ogilvy


"Annette" wrote in message
...
How would I highlight an area in a spreadsheet based on a name found
in
column A?

such as ... if the name frog was found in column A .. how would I
highlight
through a macro ... col C, D, and E all the rows that have Frog listed
in
Column A?