Conditional formatting only working for half of worksheet

M

mmurphy

Hello,

I have applied conditional formatting to highlight all duplicates in one
column. It was working fine until I added new data to the worksheet this week
and suddenly, it's not working for the new data. I've cleared the rules and
reapplied them, but it won't work for the new data.

Can someone help?
 
A

Arceedee

Where is the new data added? Is it the same column? Are you adding columns?
Is the whole column with duplicate data selected?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 6
Conditional Formatting 3
Excel 2007 conditional formatting bug? 2
Conditional Formatting 2
Pivot Table/Conditional Formatting Guru Help 2
Conditional Formatting on empty cells 6
SUMCOLOR with conditional formatting not working 3
Conditional Format Fragmentation 2

Top