•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#cloud-based spreadsheet applications
#AI formula generation techniques
#Excel compatibility
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#conditional formatting
#homeschooling
#product name
#formula
#colour
#column E
#column P
#less than 5
#WAAR
#applied randomly