pipsmultan
11-07-2015, 12:15 PM
Greeting to all Respected
i am confuse and cant figure-out the solution http://www.excelforum.com/images/smilies/frown.gif
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
14714
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
i am confuse and cant figure-out the solution http://www.excelforum.com/images/smilies/frown.gif
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
14714
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