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