Conditional Format

[Jimmytech]

I apoligize for the redundancy of this question, but all the post's
have seen on this subject have not dealt with my particular problem.
am attempting to build a monthly personal bill database that when
manually entered bills due date in Column C is within 2 days of bein
due turns yellow, and from the date due and beyond, turns red. I hav
been able to extract the information from other post on how to do tha
part (and I thank you too!), but the one part that I cannot figure ou
is that I have a Bill paid column (column E) that I would like to hav
refrenced that would override my existing conditions. Example: Colum
C is overdue by condition 1 and should be red. However, in Column
there is a "Y", therfore it would show normal. I only want bills tha
are unpaid and close to or over there due dates to change color.
side note I have always wondered is, can you have excel send a
automatic email upon a condition being met? Just curious. I hope thi
makes sense. Thank you for your help. I have found a new favorite we
site

 

[Jack Schitt]

Hi
someone else can answer the emailing bit of your question, but on the
conditional formatting:

I think it should work if you just create two separate conditions under
conditional formatting (which allows up to 3 conditions). Condition 2 is
examined only if condition 1 fails. Condition 3 (if used) would be examined
only if both conditions 1 and 2 failed.

So in your case, use condition 1 to test the content of column E, and set
the format to "no format set".
Then click on "Add.." at the bottom of the conditional formatting dialog box
to add an input focus for condition 2, and in that condition add the query
(and format) relating to column C.

 

[Mike A]

You can do it with two conditions:

Condition 1:
Formula is =AND(AND($C3>=TODAY(),$C3<=TODAY()+2),$E3<>"Y")
{Format for yellow}

Condition 2:
Formula is =AND($C3<TODAY(),$E3<>"Y")
{Format for red}

Sorry, but I have never tried to _automatically_ send an email from
Excel, but it can probably be done. Most likely you will have to have
Outlook installed on your system, and write some VBA code to create some
Outlook objects and call some Outlook functions. But, I never install
Outlook with my Office installations, so I have no idea where to begin.



Mike Argy
Custom Office solutions and
Windows/UNIX applications

 

[spencer252]

If you solve this problem I would be extremely interested in seeing it. TIA!