•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting highlighting row below targeted cell
Our take
If you're new to Excel and struggling with conditional formatting, you're not alone. Many users face challenges when trying to highlight entire rows based on specific criteria, especially in large tables. In your case, the formula you’re using, =$H4="Open," is likely not applying correctly due to how the rule is set up. Let’s explore how to adjust your conditional formatting so that it highlights the correct rows, ensuring your team can effectively track tasks as "open," "closed," or "overdue.
Hello everyone, I am new to needing to use excel but I was put into a position where we use a table to highlight tasks that are "open, closed, overdue, in progres, or overdue." Now the issue is with 20 other people who have access to this the rule that was made has been broken and is not selecting the whole row or it is selecting the row below. The column with this info is in H. The first three rows are used for headers and then from the 4th row down is what is supposed to be targeted. When I put in the rule =$H4="Open" and then apply it to the table it make row 5 turn to the color not row 4. Only other thing is the table is about 3000 rows long so maybe I am messing something up but I just started using excel last month.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Conditional Formatting not highlighting selected cells when keyword is typed into a cell range unless it’s the first cell of the rangeHello everyone! I’m working on a project for work and I’m running into an issue that I can’t solve. I work for housekeeping at a large property and we will, from time to time, shuffle around housekeepers and move their areas. I’m trying to use conditional formatting to highlight cells that resemble the different areas the housekeepers can be assigned as green once someone assigns that section to a housekeeper so they know the area is covered. So far, I’ve tried using =[Range of Cells that has a Data Validation drop list of different sections]={Name of Section from Data Validation Table} with the “Apply To” range being 4 cells several columns over from the Section Selection range. The group of cells will only highlight when the Section name is in the first cell of the range but no others. Any help would be greatly appreciated! submitted by /u/WhereTheresAMills [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]
- Conditional Formating to highlight different dates on a spreadsheet.Hi there, I need assistance with creating a formula to highlight dates that are 3 - 6 months hold and dates that are +6months from the date I open the spreadsheet. Example, this spreadsheet was created today, but if I were to open the spreadsheet on 3 weeks, the highlighted dates change according to that days dates if applicable to the rule. The data I'm trying to do this for is A1:J565. Row 1 are column titles if that makes a difference for the rule. The date colum is I. I appreciate any help I can get. submitted by /u/Salty-Departure7245 [link] [comments]