Reminder

[Misho]

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 didn’t submit his doc’s 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.

 

[Jacob Skaria]

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the below formula
=AND(ISNUMBER(SEARCH("offer",H16)),ISNUMBER(SEARCH("under
completion",J16)),TODAY()-N16>20,N16>0)

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

If this post helps click Yes

 

[Jacob Skaria]

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()-N1>20,N1>0)

If this post helps click Yes