hi guys..
i am selecting a cell containing text in conditional formatting...if one cells containing text get selected..other cells should get selected.
its going differently in my case.
please check the screenshot...if i select the cell AVAILABLE and below if FINISHED is inserted..all the cells from A3 TO E3 should get highlighted.
any suggestions...https://www.dropbox.com/s/ukkmpjq6gfdwoh8/Sample.png?dl=0
i am selecting a cell containing text in conditional formatting...if one cells containing text get selected..other cells should get selected.
its going differently in my case.
please check the screenshot...if i select the cell AVAILABLE and below if FINISHED is inserted..all the cells from A3 TO E3 should get highlighted.
any suggestions...https://www.dropbox.com/s/ukkmpjq6gfdwoh8/Sample.png?dl=0