Forum Discussion

rswann97's avatar
rswann97
Copper Contributor
Jan 16, 2019
Solved

Conditional Formatting

Can anyone do some conditional formatting on the attached document...

 

I need expired dates to turn red, any dates within 30 days to turn yellow, and all other dates to turn green.

 

I have tried doing it but there are a few cells where it isn't working.

excel

16 Replies

  • Nauthstar's avatar
    Nauthstar
    Iron Contributor
    Jan 16, 2019

    Hi,  Try the following (attached). 

    I wasn't sure what column you wanted to check so I added an additional row so you could switch checking for any column On/Off!  The box on the right controls when the records will be shown in Red, Amber or Green.

    The text in the Red, Amber and Green are for info, you can change the text to whatever you want.  It's the Yellow Boxes that are important.  

    Not sure if the date in G15 should be 01/06/2098 so I've marked it for you to check.

     

    Hope this helps.

     

     

    • rswann97's avatar
      rswann97
      Copper Contributor
      Jan 17, 2019

      Hi, 

       

      Thanks for you help.

       

      1 problem though, cells E6 & E17 should be red as they are out of date. They currently have no fill.

       

      Any ideas?

Resources