hi - hope someone can help!
i've got 5 cells in a row - i want to be able to input a number ( 1 to
5 ) into the 6th cell and automatically colour in the respective cell.
for example if i input number 3 - then i want cell number 3 to change
colour and all the rest to remain unfilled.

i've tried conditional formatting but that will only change the colour
of the input cell. i've tried the if function too but there doesn't
seem to be a option for changing cell colour.

any ideas?

cheers

AK

Hi Ak,

hi - hope someone can help!
i've got 5 cells in a row - i want to be able to input a number ( 1 to
5 ) into the 6th cell and automatically colour in the respective cell.
for example if i input number 3 - then i want cell number 3 to change
colour and all the rest to remain unfilled.

You could use the formula option of the conditional format and use this
formula (this assumes your cells are in A:E and the cell with the number
is in F1):

=COLUMN()=$F$1

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

AK,

So long as you only want to change your cells to one color you could
use conditional formatting. Say your row is A1:F1 where F1 is the 6th
cell or value that you want to use to base the conditional formatting
on. In A1 go to conditional formatting. Change the Cell Value is to
Formula is and enter the following.

=COLUMN(A1)=$F$1

Click Format and the Patterns. Select the color you want to apply if
the condition is met. Click OK, OK. Then apply the conditional
formatting to cells B1:E1 using the format painter. If you type in a
number from 1-5 in F1, you should see the corresponding cell change
color.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530902

Note: You could specify up to 3 colors based on your values in F1 but
you could not have 5 different colors, one for each cell using
conditional formatting.

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530902