Checking multiple Cell values and validating

Closed
R04 Posts 1 Registration date Saturday April 18, 2009 Status Member Last seen April 19, 2009 - Apr 19, 2009 at 01:31 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 21, 2009 at 11:13 PM
Hello,

im the basic excel user. i have been encountered with the issue where i have to check whether a particular value is present in the cell and prompt the user accordingly..

a1 b1 c1 d1 e1 f1 g1 ............
X DE Z DE L DE M........
-
-
-
-
-

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Apr 21, 2009 at 11:13 PM
This can do done with conditional formatting but i don't know exactly which type of value you wanna highlight ????? is the duplicate or any value in row or column ???? please try to give some example so i can suggest some solution ....
1