•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting to highlight time for 24 hours (different for each cell)
Our take
To efficiently highlight cells in column L that exceed a 24-hour threshold based on individual timestamps, you can utilize conditional formatting. This approach allows you to set a rule that automatically applies a red highlight to any cell where the time exceeds 24 hours, without the need to manually adjust formulas for each entry.
I would like the cells to be highlighted in red if it exceeds 24 hours based on the time and date in the individual cell. It is a large data set and it is preferable to not amend the formula in each cell individually.
For example, column L has the cells where I want the cells to be highlighted if they exceed 24 hours however each cell as a different time; L2 is Mar 20, 2026, 10:25:21 PM and L3 is Mar 20, 2026, 7:00:01 AM. The 24 hour mark for the each cell would vary.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting for highlighting cellsI have two very lengthy columns, let’s call them column A and column B. I need to highlight all of the cells in column B whose content does not appear in column A, but there are 80+ cells I’d have to check and it’d take me a really long time. I’m in no way an expert on excel but I do know I’d have to use conditional formatting, I just don’t know how to build the formula for this :( submitted by /u/Nandolvs [link] [comments]
- Conditional formatting in a single cell based on which interval it is inHi all I have a sheet where we log our machine hours (how many hours a specific machine has run for) I want to create a conditional formatting based on whether the machine has run 0-200 hours(green), 200-350 hours (yellow) or 350-500 hours (red) Hours will continually go up, so I'm either looking for a formula/formatting to recognise these intervals (eg 7250 = yellow, but also 8250=yellow), or only the fixed intervals but with a way to "reset" the counter after a service has been done to the machine. Hope this makes some sort of sense! submitted by /u/Askebon [link] [comments]
- 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]
- 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]