If I apply conditional formatting to a group of cells to make any number bold if it is greater than 10,000 it works fine. But I find that any cells with labels in them also turned bold. I tried to evaluate this in two ways, but come up with weird results. If I put the letter "u" in four cells and sum them, the sum is zero, which I expected. But if I write the formula =if(B4>10000,"Y","N"), Excel will look at the character in B4 and give me the result of "Y"! This would indicate that the letter "U" has a value greater than 10,000, even though when I sum four of them together the value is zero?
Any ideas?
Thanks.
Any ideas?
Thanks.