I a dropdown list in column a from row 1 to 49999.
In this dropdown list I have label numbers for tapes, and I have 3 different servers. For each server there rare different label #'s. So I have made 3 different colours with conditional formatting.
Now some of the labels show the wrong colour, even if I look at the conditional formatting settings(they are correct). Why will this happen.
My settings is eg.
PRA*
01*
0000*
Bookmarks