Dear sir,

i want that when C1=Suleman then next 4 or how much i selected cell change
the colour .
and one more question

i am useing that formula

=IF(I15<"None","Reefer","Bobtail")
now i want that when cell 115=none next cel become bobtail and if Cell115 =
H then next cell become Flatbed and if C115 = K then next Cell Become
Curtainsider

is that Possible Please Help Me

I don't understand the first question.

The second...are you just wanting to expand that list of truck options? If
so, try this. You can make this as big as you want, just remember to keep the
first list ALPHABETICAL or it won't work:

=LOOKUP(I15,{"H","K","none"},{"Flatbed","Curtainsi der","Bobtail"})

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Suleman" wrote:

Dear sir,

i want that when C1=Suleman then next 4 or how much i selected cell change
the colour .
and one more question

i am useing that formula

=IF(I15<"None","Reefer","Bobtail")
now i want that when cell 115=none next cel become bobtail and if Cell115 =
H then next cell become Flatbed and if C115 = K then next Cell Become
Curtainsider

is that Possible Please Help Me

My guess on part one.

Select 4 cells other than C1

FornmatConditional FormattingFormula is: =$C$1="Suleman"

Format to a color you like and OK out.


Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 13:18:08 -0800, JBeaucaire
wrote:

I don't understand the first question.

The second...are you just wanting to expand that list of truck options? If
so, try this. You can make this as big as you want, just remember to keep the
first list ALPHABETICAL or it won't work:

=LOOKUP(I15,{"H","K","none"},{"Flatbed","Curtains ider","Bobtail"})

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Suleman" wrote:

Dear sir,

i want that when C1=Suleman then next 4 or how much i selected cell change
the colour .
and one more question

i am useing that formula

=IF(I15<"None","Reefer","Bobtail")
now i want that when cell 115=none next cel become bobtail and if Cell115 =
H then next cell become Flatbed and if C115 = K then next Cell Become
Curtainsider

is that Possible Please Help Me