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?