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