Conditional formate

S

Suleman

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
 
J

JBeaucaire

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","Curtainsider","Bobtail"})
 
G

Gord Dibben

My guess on part one.

Select 4 cells other than C1

Fornmat>Conditional Formatting>Formula is: =$C$1="Suleman"

Format to a color you like and OK out.


Gord Dibben MS Excel MVP
 
Top