I have created a number of conditional formatting rules for a selected area to format fonts for specific text, however, as soon as theres text typed in that is not in any rule, it makes it red.... how can I stop this from happening?
Thanks in adbvance :cool: