•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