Forum Discussion

kpsaute's avatar
kpsaute
Copper Contributor
Jun 28, 2018
Solved

conditional formatting not applying all rules?

I'm attempting to have my cells change color based on how far away the date is from today. Most of it is functioning as expected but for some reason, the rule for between 7 and 14 days is not applyin...
Excel Desktop
Formulas & Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 29, 2018

    Hi,

     

    For that rule you have condition

    =TODAY+14

    which obviously returns an error. Please change on

    =TODAY()+14

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 28, 2018

What are your other rules? Perhaps you may attach sample file to check it.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 29, 2018

      Hi,

       

      For that rule you have condition

      =TODAY+14

      which obviously returns an error. Please change on

      =TODAY()+14

       

      • kpsaute's avatar
        kpsaute
        Copper Contributor
        Jun 29, 2018

        THANK YOU! Can't believe I missed that...

Resources