•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?
Our take
Conditional formatting can sometimes seem unpredictable, especially when it doesn't behave as expected. In your case, you're trying to color product names based on values in column E and highlight rows where column P contains "WAAR." If the formatting appears random, it may be due to incorrect formulas or the way the rules are applied. Double-check your formulas for accuracy and ensure the rules are set in the correct order.
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]
Read on the original site
Open the publisher's page for the full experience
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