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 trie...
excel
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?

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

      You are a legend!

       

      Thanks for your help.

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

        No problem, it's much easier to fix when the actual file (or example file)  is included.

        ;-)

Resources