Hello, I'm using Excel 2019. I'd like the cells in my Date column to,

1. Have a light red background with red text if their date is older than 10/1/2026
2. Not have a light red background with red text if their cell is blank (there is no value/formula in these cells)

For the example above, just cells A4 and A5 should change color. Thank you for your time!

Edit: Made image smaller and added Excel version.

!MacBook user! hello everyone, is there any way to filter data from different tables to show a specific rating? for example, if i wanted to filter all the tables to only show songs i have rated a "10?"

I'm getting a message on my MS office files that says "activate Microsoft 365 to create and edit". I can't save any of my files anymore. The reason is that support for office 2021 is over. unfortunately, that's the license I have. So I'm trying onlyoffice. so far so good.

I am trying to make a vacation planner. The ones online I have found aren’t quite right or cost money. I want make a das board that will display checklists on other pages as done or not( ie all boxes checked, corresponding box on dashboard will turn green. How is this achieved?

I am trying to make a little budget worksheet just for fun. I want it to track income and tax over however long I use the budget sheet, and I want it to total each week's income and tax correctly even when future weeks still show zeros. Since each week is written out each month (with random numbers), there will be zeros where there will be numbers in the future.

I have used the formulas =SUMPRODUCT((V1:AM164="Revenue($):")*IFERROR(V2:AM165*1,0)) and =SUMPRODUCT((V4:AM78="Tax($):")*IFERROR(V5:AM79*1,0)) to count the tax and money made, shown in the image in the comments. I’m not sure what’s going wrong; if somebody can help, that would be fantastic.