Forum Discussion

MaxH's avatar
MaxH
Copper Contributor
Nov 01, 2023

Conditional Formatting of Full Row Based on Data in One Cell Troubleshooting

Hey all!   I'm building a basic spreadsheet where I want the full row to be formatted based on a single cell. I can get the cell itself to format with the formula I'm using, but once I try to "Appl...
Excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 01, 2023

    MaxH 

    Change the formula to

     

    =AND($E1>0, $E1<TODAY()+30)

HansVogelaar's avatar
HansVogelaar
MVP
Nov 01, 2023

MaxH 

Change the formula to

 

=AND($E1>0, $E1<TODAY()+30)

  • MaxH's avatar
    MaxH
    Copper Contributor
    Nov 01, 2023

    HansVogelaar 

     

    When I make that change, this is what happens:

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 01, 2023

      MaxH 

      Why did you use $E1>TODAY()+30 instead of $E1<TODAY()+30 ?

      • MaxH's avatar
        MaxH
        Copper Contributor
        Nov 02, 2023

        HansVogelaar 

        Sorry about that, my mistake. 

         

        When I enter "=AND($E1>0, $E1<TODAY()+30)", this is what happens:

         

         

Resources