Conditional Format

From: Jimmytech (Jimmytech.1cpqzb_at_excelforum-nospam.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 00:58:25 -0500

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

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • RE: Conditional Format
    ... TIA! ... > have seen on this subject have not dealt with my particular problem. ... > due turns yellow, and from the date due and beyond, turns red. ... > is that I have a Bill paid column that I would like to have ...
    (microsoft.public.excel.misc)
  • Re: Consolidating all users into one account?
    ... possible to eliminate all this extra user and administrator account ... This would also eliminate the near redundancy found in the Start Menu ... The "Bill" folders contain things that only Bill users ... you cannot login as "All Users" nor can you login as "Default ...
    (microsoft.public.windowsxp.general)
  • Re: Consolidating all users into one account?
    ... This would also eliminate the near redundancy found in the Start Menu ... It just gets a bit confusing keeping track of where everything is stored ... The "Bill" folders contain things that only Bill users ... If there are items in both desktops, ...
    (microsoft.public.windowsxp.general)
  • Re: clips for AMT .380
    ... Roger,I don't know if this fits the bill for what you want but I have ... dealt with these folks before with no problem. ... Ray, ...
    (rec.guns)
  • Re: Problems opening Wordpad from java (but notepad works just fine....)
    ... Bill wrote: ... Your future lack of top-posting, ... This type of question is best dealt with on a group such ...
    (comp.lang.java.gui)
Quantcast