Forum Discussion

gergelycsaszar's avatar
gergelycsaszar
Copper Contributor
May 07, 2021
Solved

Conditional formatting help needed

Hi all,   I'm trying to set up a rule for conditional formatting but kind of stuck.   I have a sheet with a list of invoices. I want to highlight rows that are past due date and haven't been paid...
excel
Formulas and Functions
ericGuyaderBerger's avatar
ericGuyaderBerger
Copper Contributor
May 07, 2021

gergelycsaszar 

 

Hi Greg,

 

You could Use the formula as shown below.

 

 

Note that dates are franche formated in this picture, and that references to E2 and D2 are relative so that the formula can work for every selected cell.

 

Hope this helps!

 

gergelycsaszar's avatar
gergelycsaszar
Copper Contributor
May 07, 2021

ericGuyaderBerger 

 

thank you for the quick reply, however I couldn't manage to apply the rule properly. I have attached a slimmed down version of the XLSX, can you please have a look and let me know what I missed? I would like to highlight the entire row where the date is before today AND there is nothing in the "PAID" column.

 

thanks a lot

    • gergelycsaszar's avatar
      gergelycsaszar
      Copper Contributor
      May 07, 2021
      awesome, thank you very much. is there a way to highlight the whole row not just the cell?
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 07, 2021

        gergelycsaszar 

        Full row is highlighted, please check the file.

         

        As a comment, I'd convert your range into structured table (Ctrl+T), when rules will be expanded automatically.

Resources