conditional formatting based on other cell (over multiple Rows & Column)

[pipsmultan]

Greeting to all Respected

i am confuse and cant figure-out the solution

I want to highlight from "AQ14:FH14" down across With Red Shade automatically

when "SL" text is selected from "D14:AH14" to down across

i can not do it with conditional formatting with single range formula "=D14="SL". when i use this formula in conditional formatting it only highlight one cell "AQ"

i required to highlight two cell "AQ & AR"

plz find the excel sheet file
conditional formatting based on other cell (over multiple cells).xlsx

can VB code do it. Or any formula in conditional formation

any help will be highly appreciated

as an reference

http://www.excelforum.com/excel-programming-vba-macros/1112439-conditional-formatting-based-on-other-cell-over-multiple-rows-and-column.html

Regards