In May data I want Excel to remind me for each row if the any rows got the
following applicable conditions:
1- If the H col. cell have the text (offer) and X col. Cell have the text
(Doc's Under Completion)
2- Then the date in N cells will give me a reminder after 20 days ( This
candidate didnt submit his docs to agent Yet ).

3- Can I let it give me this reminder every one week until one of the above
cells H or N change to another text.

You can use conditional formatting to highlight the cells if all the
conditions you mentioned is satisfied..If you mean a message box to be popped
up as a reminder then it is possible only with the help of macros...If you
are looking for conditional formatting of cells you can try out the below
formula/method

1. Select cells in column N . say N1:N10. Please note that the cell
reference N1 mentioned in the below formula is the active cell in the
selection. Active cell will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=AND(ISNUMBER(SEARCH("offer",H16)),ISNUMBER(SEARCH ("under
completion",J16)),TODAY()-N1620,N160)

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Misho" wrote:

In May data I want Excel to remind me for each row if the any rows got the
following applicable conditions:
1- If the H col. cell have the text (offer) and X col. Cell have the text
(Doc's Under Completion)
2- Then the date in N cells will give me a reminder after 20 days ( This
candidate didnt submit his docs to agent Yet ).

3- Can I let it give me this reminder every one week until one of the above
cells H or N change to another text.

Correction to the formula...with columns H,X and N..

--Selection is N1:N10 wth activecell N1

=AND(ISNUMBER(SEARCH("offer",H1)),
ISNUMBER(SEARCH("under completion",X1)),
TODAY()-N120,N10)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

You can use conditional formatting to highlight the cells if all the
conditions you mentioned is satisfied..If you mean a message box to be popped
up as a reminder then it is possible only with the help of macros...If you
are looking for conditional formatting of cells you can try out the below
formula/method

1. Select cells in column N . say N1:N10. Please note that the cell
reference N1 mentioned in the below formula is the active cell in the
selection. Active cell will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=AND(ISNUMBER(SEARCH("offer",H16)),ISNUMBER(SEARCH ("under
completion",J16)),TODAY()-N1620,N160)

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Misho" wrote:

In May data I want Excel to remind me for each row if the any rows got the
following applicable conditions:
1- If the H col. cell have the text (offer) and X col. Cell have the text
(Doc's Under Completion)
2- Then the date in N cells will give me a reminder after 20 days ( This
candidate didnt submit his docs to agent Yet ).

3- Can I let it give me this reminder every one week until one of the above
cells H or N change to another text.