•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting Rule for duplicates not working for pasted in text
I am at my wits end. All I'm trying to do is compile a list of business names and for some reason, if I paste any in, the rule simply doesn't care.
I've triple checked for any hidden spaces or indents and purged the column, which to my utter bewilderment has broken the rule all together. It only seems to work when I type text in or paste from a different cell but nothing else.
Any ideas?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#business intelligence tools
#Excel alternatives
#Excel
#Conditional Formatting
#duplicates
#business names
#pasted text
#hidden spaces
#indents
#purged column
#cell
#rule
#formatting
#text input
#typing