•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?
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions