Hello all,

In the attached spreadsheet I am looking for two types of alert.

a) If any cell a2:a19 is left out then an alert message saying "Please enter data in "--" cell". Actually, the range a2:a19 is a dynamic range.

b) Background: Values in Column A and Column B can be Duplicate, but values in Column C (Sub-item No.) cannot be duplicate corresponding to its Item No. in Column B.

If a sub-item no. is repeated in column c then corresponding rows should be highlighted just like in the attached sheet with a message saying "You have duplicate entry in cell " " and " " !" (Cell address is optional but red color highlight is really needed to find the duplicates.

Is this possible?

I wouldn't necessarily fire up a messagebox - this may be irritating for the user.

I would work with conditional format.

a) =ISBLANK(A2) should color the empty cells. (select the entire range when inputing the conditional format formula)

b) the easiest way would be to insert a helper hidden column, A2&" "&B2&" "&C2 and use COUNTIF() for conditional formatting:

=COUNTIF($D$2:$D$19,$D2)>1

should format the A2:C19, duplicate rows, if entered with A2:C19 selected.

I am writting all this without testing, so I hope I didn't make any typo (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

Hello Martin,

That is a perfect solution for me. Thanks again (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

You're welcome.

I really hope one can understand what I have written (IMG:http://www.utteraccess.com/forum/style_emoticons/default/dazed.gif) (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)