+ Reply to Thread
Results 1 to 3 of 3

struggling with RAG tables

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Coventry
    MS-Off Ver
    Excel 2003
    Posts
    1

    struggling with RAG tables

    I'm putting a table together and in one column where a date will be I need it to be green until the date expires then it needs to turn red. can anyone help me and explain how I do this?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,703

    Re: struggling with RAG tables

    Conditional Formatting.

    Watch this video

    http://www.datapigtechnologies.com/f...rmatexcel.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: struggling with RAG tables

    If the above video doesn't get you going, try these links that deal specifically with conditional formatting for expiration dates

    Conditional Formatting Expiration Dates

    YouTube - Conditional Formatting Expiration Dates
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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