I believe Conditional Formatting will satisfy your request.

Try something like this:

Select B1:M1
Format|Conditional Formatting
Formula is: =(column(b1)-1)=$a1
Click the [Format...] button and set yoiur format
Click the [OK] buttons

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Corrine" wrote:

How can I get a cell to highlight elsewhere in a row by entering a number
into the origin cell.

Say I am in A1 and type in 8, well 8 cells to the right should be highlighted.
How do I do that?
PLEASE help.