cell highlighted # from original cell
 

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.

cell highlighted # from original cell
 

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.

cell highlighted # from original cell
 

What do you mean by highlight? Do you want the cell to the right to be
selected, or do you just want it to change colors?

If the latter, then select all the cells to the right of A1 & go to
Format-Conditional Formatting... Select 'Formula is' and enter

=(COLUMN()=$A1+1)

Then click on the format button and choose the color you want on the
patterns tab. Ok back to the spreadsheet


"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.