Forum Discussion

Timothy Herndon's avatar
Timothy Herndon
Copper Contributor
Jul 07, 2018

Color Coding by Date

I am trying to build a spreadsheet that automatically color fills a date cell by whether the date has already past (red), is within 7 days (yellow), or further out than 7 days (white).  I've tried using the Conditional formatting, but I must not be doing it correctly, as it doesn't color code anything, or color codes everything red.  Any help?

  • Hi Timothy,

     

    In general CF shall work for your case. If you explain in more details which rules you use or , even better, submit some sample file, it'll be easier to answer what's wrong.

    • Timothy Herndon's avatar
      Timothy Herndon
      Copper Contributor

      Here's the sheet I was working on.  I want dates prior to whatever the current date us to be red, those within 7 days to be yellow, and those more than 7 days out to remain white.  It should color code depending on the current day, not the day I'm building it.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Hi Timothy,

         

        You need two rules

        red one

        =($A3<=TODAY())*($A3>1)

        where the second part excludes blank cells; for yellow

        =($A3<=TODAY()+7)*($A3>1)

        Rules are in sequence as above. The rest, i.e. TODAY()+7 will be blank. File is attached.

Resources