1 min readfrom 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

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.

submitted by /u/Mk1Racer25
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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