+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting - colour fill entire row by date range

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Talking Conditional formatting - colour fill entire row by date range

    Hi all,

    First time user and poster

    I am currently working on a spreadsheet for work which has contact details of our major clients. The issue that we seem to have is that the contact details need to be updated regularly to remain relevant.

    I have a column called "last updated" where the staff member inputs the date that the details have last been changed (eg. 20/06/2012).

    What I want to do is to set conditional formatting rules where those clients that have been updated in the last 30 days is set green (the whole row and not just the field), those updated between 30-90 days is set orange and those updated later than 90 days is set red.

    I have been busting my brain cells trying to figure this one out and have only managed to google on how to do it to one cell, or to one line, etc.

    Greatly appreciate your help!

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Conditional formatting - colour fill entire row by date range

    hi oOLILYOo, welcome to the forum. assuming your data is from A2:F10 & dates "last updated" is in column F, highlight them & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    Green:
    Please Login or Register  to view this content.
    Repeat the above steps again & do these formulas for orange & red.

    Orange:
    Please Login or Register  to view this content.
    Red:
    Please Login or Register  to view this content.
    also, your green & orange kind of overlapped. last 30 days & 30-90. so i changed the orange to 31-90.

    if it still can't work somehow, do upload a sample for us. press "Go Advanced" beside the "Post Quick Reply" & click on the paperclip icon

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    08-01-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional formatting - colour fill entire row by date range

    Thanks so much benishyro! Funny thing is, I figured it out once I posted this thread but your answer helped me confirm that I was doing it right. Awesome to have such a quick response!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1