conditional formatting affecting empty cells! help please?

[juntjoo]

it's simple and strange at the same time, as excel often is, but basically i have a several columns with conditional formatting check themselves against other sheets, and each column has the same formula checking against various named sheets, same same same... but then I added a new sheet and it's corresponding name and added that name to all CF rules of all the columns, so everything is the same BUT now all of a sudden all my columns are pink where it's empty. still works if I get duplicates but I'd just like to know why this is happening and all this pink is... I don't know the word. reminds me of cotton candy. any ideas?

 

[FDibbins]

CF can do strange things when copied to other cells/sheets, I have seen cases where the rules got repeated many times over, within the same cell.

Check your rules to make sure they are all still correct and not duplicated
If the same rules were working fine in other areas, and now suddenly don't, check to see what's changed
Share your rule/s here so we can see what's happening

 

[juntjoo]

CF can do strange things when copied to other cells/sheets, I have seen cases where the rules got repeated many times over, within the same cell.

Check your rules to make sure they are all still correct and not duplicated
If the same rules were working fine in other areas, and now suddenly don't, check to see what's changed
Share your rule/s here so we can see what's happening

Thanks. Let me take out my magnifying glass and spend a little time on this. Strange tho. All I did was add this new named range into each of the formulas. Countif's. Against a bunch of different named ranges in other sheets. All named ranges go across a few columns and run down to the bottom of their respective tables except.... except the new who's named range isn't of a table. That's the only thing that is different. It's just a group of cells I manually selected as that sheet doesn't have a table, unfortunately as I wanted it to be a table but that's another story. I will experiment by throwing a temporary table in to connect to that name and see if the pink goes away...