•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to figure out conditional formatting of a cell based on its value and the value of another cell
Our take
Conditional formatting can enhance your data visualization by changing cell backgrounds based on specific criteria. In your case, you want to format the product type cell based on its value alongside another attribute, such as highlighting "1A" with "WD" in yellow and "HM" in blue. If your formula (e.g., `($J19 = "1A" AND $I19 = "HM")`) isn't working, it may be due to syntax issues or incorrect cell references. Let’s explore the right approach to achieve the desired formatting effectively.
One column my data has a product type (e.g. 1A, 1B, etc.), and another column has an attribute (e.g. WD, HM, etc.)
All product types can have all attributes. I'm trying to format the product type cell background based on a given combination of product type and product attribute (e.g. 1A + WD would be yellow, 1A + HM would be blue, etc.).
I've tried using a formula to control the formatting (e.g. ($J19 = "1A" and $I19 = "HM")), and setting the fill color, but it does not appear to be working (cell fill is not changing). Not sure what I'm doing wrong here.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Why does my conditional formatting appear random?This is for school (homeschooling. I don't have access to quick or direct contact with a teacher, which is why I'm here). I've received a video of instructions for how conditional formatting works, and I feel like I'm doing what was in the video. But the formatting seems to get applied randomly. Here, I need to colour the product name based on if column E is less than 5 Here, I need to colour the rows based on if column P is \"WAAR\" Did I write the formula wrong? Is it something else? submitted by /u/Independent-Total861 [link] [comments]
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [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 based on a different cell's valueI'm fumbling my way through conditional formatting on a tracking sheet I'm creating. I have the status and required delivery formatting the way I want, but now I'm running into an issue where I want it to clear the formatting of the required delivery cell once the status cell is set to "complete" like the bottom row. The status cells are drop down menu if that makes a difference. https://preview.redd.it/0va9fhl9tlvg1.png?width=346&format=png&auto=webp&s=a470a51c639e165a0e4bb41b626d60743cf457c1 I've tried playing around with "IF" formulas, but nothing seems to be happy with what I'm trying. Any thoughts? submitted by /u/Senior_Cheesecake155 [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#cloud-based spreadsheet applications#AI formula generation techniques#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#formula generator#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#conditional formatting#product type#attribute