Conditional formatting based on multiple criteria

[exceltwinkle]

Hello everyone,

I am looking to write a formula that would allow me to apply conditional formatting to a range of cells within a pivot table based on multiple criteria.

If “date1” is before today and has “units” I would like “date1” to be highlighted (like in the example). Any ideas on how to do this?

 

[James006]

Hello,
You could test

=AND(B6<TODAY(),D6>0)