conditional fill colour

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

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

[SteveG]

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]

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

[Jan Karel Pieterse]

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