Help needed with Google Sheets formatting!
I’m having trouble with my spreadsheet’s appearance. I set up two conditional formats:
- One to make every other row have a different background color
- Another to change the text color of cells with duplicate content
The problem is these formats are fighting each other. When the text color changes for duplicates, it erases the background color of the even rows. If I switch the order of the formats, I get the row colors back but lose the special text color for duplicates.
I’m not sure how to make both formats work together. Is there a way to keep the alternating row colors AND have the duplicate text show up in a different color? Any tips or tricks would be super helpful!
Thanks in advance for any advice on fixing this formatting clash.
have u tried using custom formulas for both rules? like =MOD(ROW(),2)=0 for even rows and sumthin else for dupes. might help em play nice together. also check the order of ur rules in the conditional formatting menu. sometimes switchin em around does the trick. good luck!
I’ve encountered this issue before, and there’s a workaround that might help. Instead of using conditional formatting for the alternating row colors, try using a custom formula in your conditional formatting rule. Something like =MOD(ROW(),2)=0 for even rows and =MOD(ROW(),2)=1 for odd rows. This method tends to play nicer with other conditional formatting rules.
For the duplicate text color, make sure this rule is applied last in your conditional formatting order. You can adjust the order by going to Format > Conditional formatting and dragging the rules to reorder them.
If you’re still having trouble, consider using custom formulas for both conditions. This approach gives you more control over how the rules interact and can help prevent conflicts between different formatting rules.