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
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.

      ;-)

      • johnc47's avatar
        johnc47
        Copper Contributor
        Aug 14, 2019

        I was hoping you could assist me with a similar problem? My spread sheet has membership dates in one column and expiry dates in the adjoining, I had it set up so if the exoiry dates were exceeded, the cells high lighted with a red fill. This no longer seems to be working, could you help me please? Nauthstar 

Resources