+ Reply to Thread
Results 1 to 4 of 4

conditional formatting- before today, another after today passes

  1. #1
    Registered User
    Join Date
    09-13-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    conditional formatting- before today, another after today passes

    Hi, I have created an Excel spreadsheet- bill payment tracker. Using the column with dates of bills that "need to be paid by", I've used conditional formatting to background fill colours for 2, 7, and 10 days before they are due.

    What I can't do, is use conditional formatting to background fill the cell with a colour when "today's date" has come and gone. What I'm getting is a conflict with the above, because the rules mentioned above, point to past dates (with respect to "today"). Note: when I prioritise the order of rules, it didn't work.

    Thank you.

    Regards,

    Edward- from Australia

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,786

    Re: conditional formatting- before today, another after today passes

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    09-13-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: conditional formatting- before today, another after today passes

    Sorry, please see attachment.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-13-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: conditional formatting- before today, another after today passes

    I finally figured out a work around (see attachment). It isn't sophisticated, but it works.

    Maybe someone else can suggest a better more concise way to get the results?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional formatting if date is before today
    By TimmerSuds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2018, 08:33 AM
  2. [SOLVED] Conditional Formatting for 2 months from today
    By drunkchicken in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-22-2017, 09:47 PM
  3. [SOLVED] Conditional Formatting for TODAY
    By tapsmiled in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-25-2014, 09:18 PM
  4. Conditional Formatting help with =Today()
    By Prosatinos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 06:56 AM
  5. Conditional Formatting Today and Older
    By ConsbruckR in forum Excel General
    Replies: 7
    Last Post: 03-18-2009, 04:31 PM
  6. Replies: 3
    Last Post: 12-11-2007, 01:36 PM
  7. Conditional Formatting ... Today() & More
    By Ken in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06865 seconds
  • Memory Usage 8,958KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (4)postbit_legacy
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1