•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