dear experts
help on my post
i have set of list values in column b and c in column b contains full lenght of text and column c have short cut keys for a cell values
i want apply condition formatting for particular column from short cut keys column c
e.g 1i have short letter 24/7 in keylist result in H:H columns any where appear( 24/7 Customer or Customer 24/7 )
i want make the cell color.
ONE MORE E.G
IF TATA M In the list keys if any words comes like TATA MOTORS OR TATA MOPHED MAP COLOR
thanks alot
find the attachment you may understand easily.......
Bookmarks