I’m having trouble with multiple conditional formatting rules in Google Sheets. I set up one rule to make every other row have a colored background, which works fine by itself. Then I added another rule to change the text color when there are duplicate values in cells.
The problem is that when both rules are active, they don’t work together properly. The duplicate text formatting seems to cancel out the alternating row colors. When I change which rule has higher priority, I can only get one to work at a time - either the row backgrounds or the duplicate text colors, but never both.
Has anyone figured out how to make multiple conditional formatting rules work together without one overriding the other? I need both the alternating row backgrounds and the duplicate value text highlighting to show up at the same time.
I encountered the same problem recently, and what helped me was to ensure that my duplicate rule affects only text properties and avoids any background adjustments. I opted for bold text with a darker color rather than changing backgrounds or borders. Additionally, check the order of your rules; I found that placing the alternating rows rule at the bottom of the list resolved the conflict for me. Be mindful of your cell ranges too; targeting specific ranges for each rule instead of the entire sheet can prevent confusion, especially when rules overlap. If issues persist, consider recreating the duplicate rule, focusing solely on text modifications.
try keeping your duplicate rule away from background properties - just change font color and weight. had the same problem and fixing rule order helped, but double-check that your ranges match exactly between both rules. sheets acts weird when ranges don’t line up perfectly.
The issue you are experiencing arises from the way Google Sheets processes conditional formatting rules sequentially, which can lead to one rule overshadowing another if not set correctly. From my own experience, a useful approach is to ensure that each rule targets specific elements distinctly. For example, let your alternating row color rule only adjust the background and leave any text formatting untouched. Conversely, your duplicate value rule should focus solely on text alterations, such as changing text color or applying bold formatting, without affecting background colors. Additionally, verify that the ranges of these rules do not overlap in ways that could cause conflicts. I recommend testing each rule individually before combining them, and prioritize the duplicate text rule, as making duplicates visible is often more crucial in data analysis.