•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting with formulas
Our take
Conditional formatting with formulas can significantly enhance your spreadsheet's functionality, particularly when tracking ordered parts and their delivery statuses. To ensure that cells highlighting the requested delivery date turn red when they are less than 14 days away, you need to set the correct conditional formatting rule. It’s essential to check that your formula accurately references the dates and that the formatting is applied to the correct range. This straightforward adjustment can help you maintain oversight of your orders and ensure timely follow-ups.
I am trying to create a spreadsheet to track ordered parts and their status, including their requested delivery date.
What I'm trying to sort out, and failing at, is setting a conditional format so that when the requested delivery date is less than X days out (say 14 for now), I want it to highlight the cell red so I can check on the status of the order.
This is my current rule configuration, which I set by selecting the column so it auto populates as it's filled in.
Inconveniently, it's doing the exact opposite of what I want:
In this instance, ONLY 4/13 should be highlighted (I'm not worried about the top row at this point, I'll fix that after).
I've even tried creating another column to do the math, and use that cell for the formula, and that's not working either. It seems like it should be straight forward, but I apparently lack the formatting skill.
[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 based on a different cell's valueI'm fumbling my way through conditional formatting on a tracking sheet I'm creating. I have the status and required delivery formatting the way I want, but now I'm running into an issue where I want it to clear the formatting of the required delivery cell once the status cell is set to "complete" like the bottom row. The status cells are drop down menu if that makes a difference. https://preview.redd.it/0va9fhl9tlvg1.png?width=346&format=png&auto=webp&s=a470a51c639e165a0e4bb41b626d60743cf457c1 I've tried playing around with "IF" formulas, but nothing seems to be happy with what I'm trying. Any thoughts? submitted by /u/Senior_Cheesecake155 [link] [comments]
- Conditional Formatting for Dates Missing Numbers (i.e. 3/11/202 instead of 3/11/2026)Does anyone have a formula for formatting dates that are missing numbers? I have created a complex tracker, but it cannot do its job if the user does not enter the date right. I know I cannot stop user error, but I am hoping that it could mitigate some of it if the cell turns bright red when they have done something wrong. I tried and the "ISDATE" function is not working for me. Additionally, I do have text in the document that I do not want formatted so I was playing around with =AND(ISNUMBER(A3),... as the beginning, but could not figure out an end. I also tried typing out an "example date" and having the formula reference that formatting and highlighting the incorrect dates, but I could not get that to work either. Any help is greatly appreciated, please let me know if you have any questions! https://preview.redd.it/r4fuw96cwfvg1.png?width=307&format=png&auto=webp&s=7c8f9db16ceb090d43fc9c8b2b278f32acbb7689 submitted by /u/ClassroomHairy9513 [link] [comments]
- Set conditional formatting formula to change cell colors after conditions are met in a separate tabI'm doing r/Fantasy's reading Bingo challenge this year, and thought I'd set up a spreadsheet to help me track my progress. The conditional formatting formulas have been causing me some trouble, though: In Tab 1, I have the Bingo squares arranged in the usual 5x5 grid, and in Tab 2, I have all the squares & their reading rules, hard modes, and completion statuses laid out. I'd love to set it up so that if, in Tab 2, I mark "x square" as completed in "EASY" mode, then the equivalent "x square" cell in the 5x5 grid will automatically change color in Tab 1. Ideally the 5x5 grid won't need any manual color formatting, and I'll only need to edit Tab 2. But I haven't been able to figure out how to make this work across the two separate tabs. In case I'm not describing it well, I'm including an editable Google Sheets version of the spreadsheet for reference: https://docs.google.com/spreadsheets/d/1S6EtJFLLSoysxIp-HHZT_tjVznucJuDbhqpDhbdPZX0/edit?usp=sharing Thanks so much in advance! submitted by /u/defenestratedduck [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#AI formula generation techniques#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#row zero#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#formula generator#Excel alternatives#spreadsheet API integration