Conditional Formatting Doesn't Work

Question

I have been working on tihs for hours, and I know it shouldn't be this difficult. I have a spreadsheet with a formula in a column that calculates the percentage of overtime of total hours worked. If that percentage is greater than 10%, I would like for the cells to be shaded. The problem is that whenever I use the formulas, I get eihter an error message or it shades the entire column, regardless of the value. I'm using excel 2010.  My steps are:

1. highlight the column where I want to apply conditional formatting.
2. choose conditional formatting, new rule, use formula to determine which cells to format
3. type in formula space =cc4>=10%
4. choose the shading/fill color
5. click okay and okay.

Result is the entire column shaded red, even though only one cell has any number!!!!!! Even when I choose to use a regular conditional formatting option without formulas, the result is the same.

Can anyone tell me what is going wrong with this? All the online tutorials I've viewed follow the same steps, but with the correct results.

Answer 1

Thank you, benishiryo. That worked! I don't understand the logic in the formula though. Why would I need to say and if cc4 is greater than or equal to 10%, shade red, otherwise cc4 is less than greater than blank?