•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Attempts at conditional formatting
Our take
Are you struggling with conditional formatting in your spreadsheet? You're not alone. Many users find it challenging to visually track submission statuses, particularly when dealing with empty cells. While you've successfully set up your status columns to indicate on-time (green) and late (red) submissions, the issue arises when dates are missing, leading to unexpected results. Fortunately, there's a straightforward solution. By making a few adjustments to your conditional formatting rules, you can ensure that empty cells remain neutral, allowing for clearer insights into your data.
Hi all- I'm attempting to create a sheet to show when submissions are late and when they are on time. I figured out how to conditionally format the "status" columns so they show green and red based on the value within them, but I'm running into an issue that when there has NOT been a value (date) assigned, it subtracts the date from nothing as opposed to..... doing nothing. I'm sure this is a simple answer for you guys, but I'm new, so please be kind.
[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 Issue Between DatesHello 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. submitted by /u/SDEMPSEY90 [link] [comments]
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [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]