Checking multiple Cell values and validating

Closed
R04 Posts 1 Registration date Saturday 18 April 2009 Status Member Last seen 19 April 2009 - 19 Apr 2009 à 13:31
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 21 Apr 2009 à 23:13
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 12 April 2009 Status Member Last seen 16 February 2010 166
21 Apr 2009 à 23:13
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 ....