+ Reply to Thread
Results 1 to 2 of 2

Change row color based on TODAY>=specific date

  1. #1
    Registered User
    Join Date
    01-10-2008
    Posts
    5

    Change row color based on TODAY>=specific date

    Hello,

    I tried an if statement with no success.
    What do I need to do to change a row color based on:
    yellow if the date in a row is bigger than today
    and
    red if the date in a row is smaller or equal to today

    Cheers, and thank you in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    Have you tried "Conditional formatting"
    I think you can make it.
    Format > Conditional Formating
    I need your support to add reputations if my solution works.


+ 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. Change date to the following Sunday
    By pilotwings64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2008, 06:34 PM
  2. NETWORKDAYS between 1 fixed and 1 variable date
    By Regg1e in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-08-2008, 05:21 AM
  3. Date colour change in a range
    By brianzs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2008, 10:28 AM
  4. Insert Row with month of date change
    By cindy7 in forum Excel General
    Replies: 2
    Last Post: 07-30-2007, 07:14 AM
  5. Date change
    By Alive in forum Excel General
    Replies: 2
    Last Post: 04-17-2007, 11:07 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1