•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting entire row based on value in column
Our take
Are you struggling to apply conditional formatting to an entire row based on overdue days? You’re not alone—many users find themselves frustrated when legacy spreadsheets don’t behave as expected. Imagine effortlessly highlighting rows in your data, making overdue tasks pop out at a glance. In this guide, we’ll show you how to format columns A:M based on the values in column G, ensuring that overdue items are clearly visible. Keep reading to transform your spreadsheet experience and regain control over your data!
I feel stupid putting this out there, but it's not my first "duh" question and it won't be my last.
I am currently attempting to higlight the entire row of columns A:M (62 rows) based on the column of days overdue in G.
Ideally, this would be:
If value in G is between 1-15, format light green
If value in G is between 16-30, format yellow
If value in G is 31+, format red.
My current super lame attempt only applies the conditional formatting to B:G, AND it's including 0s. I'm absolutely losing my mind over this simple thing. Any help would be greatly appreciated!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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 highlighted cellsHoping you can help me! Everyone at my office is a huge novice with Excel - I understand the basics but am not terribly great myself. We need one (hopefully) simple thing. Essentially, we have a dataset that we want to flag column A with a highlighted color if anything in that row is a color. Column A will always contain one of 5 words -- I've already done that with data validation. But what we want is, for instance, if I highlight cell H7 in yellow, it would then highlight A7 with the same color. I tried playing around with conditional formatting but I wasn't able to get it quite right. Thanks in advance for any assistance you can give! submitted by /u/THE_GREAT_PICKLE [link] [comments]
- Attempts at conditional formattingHi 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. https://preview.redd.it/i2be9mckhajg1.png?width=391&format=png&auto=webp&s=7f7a6317ebc036066f4a45276ee4b8197e1265ca submitted by /u/Dizzy-Cabinet-7093 [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]