•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why is my Custom Conditional Formatting not working?
Our take
If your custom conditional formatting isn’t working as expected, it can be frustrating, especially when you’re trying to highlight specific data in your spreadsheet. In your case, the formula you used, =AND($E2=3, $F2=2), is correct for identifying houses with 3 bedrooms and 2 bathrooms. However, issues might arise from how the formatting is applied or the range selected. Ensure that you've applied the formatting to the correct cells and double-check for any inconsistencies in your data that could affect the results. Let's troubleshoot this together.
So I am trying to highlight green a spreadsheet of House information. I want all houses that have 3 bedrooms and 2 bathrooms to be highlighted green. The bedroom data starts from E2 and the bathroom data starts from F2
So I have used this exact formula =AND($E2=3, $F2=2) and selected the cells that return this data to be highlighted green with bold text. But when I click okay on the custom conditional formatting rule nothing happens. Nothing is highlighted green although I clearly see houses that meet my ‘highlight green’ criteria on the spreadsheet.
Please help me out, what do I do?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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 highlights wrong cellsI have a simple formula of =$L2="yellow" to format my data, but it's highlighting my Green and reds too... I'm not sure what's happening. I need an adult please help submitted by /u/NoMoArtichoke [link] [comments]
- Conditional formatting with formulasI 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. https://preview.redd.it/n4g68xoihzsg1.png?width=409&format=png&auto=webp&s=6715ebba2e873e171fad3b862ff3a7d188b4b3a1 Inconveniently, it's doing the exact opposite of what I want: https://preview.redd.it/h7a7in7ohzsg1.png?width=294&format=png&auto=webp&s=1168efcd78872a5158cd045e6c3ea642c1328152 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. submitted by /u/Senior_Cheesecake155 [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]