•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting Issue Between Dates
Our take
Managing dates in spreadsheets can be a challenge, especially when conditional formatting doesn’t behave as expected. If you're tracking paperwork submissions and want to highlight recent entries with a red background for those within the last 90 days, it’s frustrating when the formatting fails. Your current setup might need a slight adjustment to ensure it captures those critical dates. Let’s explore how to troubleshoot this issue so you can seamlessly visualize your data and enhance your workflow.
Hello all,
Fully admitting I am not the best at Excel so be nice please.
I am using a spreadsheet in my job that I use to track dates for service users.
I have a column for any time that a user has received a piece of paperwork.
If it has been beyond 90 days then I have the conditional Formatting set to a green background. The formatting for this is cell value > less than > today() -90
The issue is when I'm trying to have a red background for any paperwork submitted within those 90 days. I had this already formatted with cell value > between > today > today() -90
This worked up until today. I put in a value for a few days ago and the background has turned white instead of red and I can't seem to fix it.
Any help would be greatly appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Conditional formatting for datesHow would I achieve automatic colour changing dates with exceptions. For example I need to be able to put in any date for applications (so they don't exist yet.) and then after 30 days i need it to go orange and then from that 30 days another 7 days it goes red but if the completed column is checked i need the conditional formatting to be invalid as it wont be necessary for the colours to change. How do i achieve this? column - date application received (23/02/2026) turn orange at (23/03/2026) turn red at (30/03/2026) stays white or turns white is column competed has "D" submitted by /u/No-Sink-6054 [link] [comments]
- How to use TODAY() to conditionally format due dates?I am a complete noob at excel so my apologies if this is very easy. Essentially, I am trying to make a column where I write the last date I received records. I’m supposed to get updated records at least once every 90 days, but frequently they’re late. I want the cell to turn red if the date in it is older than 90 days. The column is K and the first cell with info is K2. I tried =K2<TODAY()-90 and =$K$2<TODAY()-90, but the test dates I tried either don’t turn red when they should or *all* of them turn red even if left blank. What formula should I use? submitted by /u/boopbaboop [link] [comments]
- Conditional formatting based on range of values in different column?https://preview.redd.it/l3guc8q9wfog1.png?width=1324&format=png&auto=webp&s=ec9fba2147eebc33af9e108241f82cb9163cf512 I've tried several different ways to do this but clearly I'm missing something. I have spreadsheet that shows the hours scheduled on all the machines at our facility. The dates in row 2 auto populate based on today's date. I want to make a rule that changes the formatting of rows 3 - 12 if any of the dates in row 2 are company holiday. For example, if B2 matches any of the dates in R3 through R12, I want B3 through B12 to fill in black with red text, so that way it shows that date is blacked out because we're closed, but if someone accidentally scheduled an order that day the machine hours will show in red so they know to reschedule it. On the original version of this spreadsheet I made a few years ago I had the same issue and end up just using =B$2=$R$3, so for each day I had to make 10 different rules for every holiday in column R. I knew that definitely was not the best way to do it but I was tired of messing with it and just needed it to work. I am updating this spreadsheet and it now shows the next 60 days instead of the next 14 days and I know there's got to be a better solution than creating 10 different rules for each day. I know =B$2=$R$3:$R$12 does NOT work and I think I'm starting to smell burnt toast. submitted by /u/BluestockingLife [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#rows.com#modern spreadsheet innovations#self-service analytics tools#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#financial modeling with spreadsheets#automation in spreadsheet workflows#no-code spreadsheet solutions#Conditional Formatting#Excel#dates