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?