cell highlighted # from original cell

C

Corrine

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

Ron Coderre

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
 
D

Duke Carey

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
 
Top