megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 140
- Office Version
- 365
- Platform
- Windows
I have a table of income reported by each of our locations by date and we indicate if it's been Deposited or is Uncollected,then I have a PivotTable summarizing this info, grouped by location.
I want to highlight if there is a value/an amount greater than $0 in the Uncollected Amount column if the date it was recorded is more than 1 day ago.
I wrote this formula in Conditional Formatting but it's not working. The circled numbers should be highlighted because 11/1/2021 is more than 1 day ago.
=and(J4<TODAY()-1,K4>0)
I've tried removing the absolute reference on the applies to ($K$4) or just saying applies to "Selected Cells" but it always puts it back.
I want to highlight if there is a value/an amount greater than $0 in the Uncollected Amount column if the date it was recorded is more than 1 day ago.
I wrote this formula in Conditional Formatting but it's not working. The circled numbers should be highlighted because 11/1/2021 is more than 1 day ago.
=and(J4<TODAY()-1,K4>0)
I've tried removing the absolute reference on the applies to ($K$4) or just saying applies to "Selected Cells" but it always puts it back.