PDA

View Full Version : conditional formatting based on other cell (over multiple Rows & Column)



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