Excel 2010 Conditional Formatting using IF between two columns

[cookmd]

	J	K
1	pct 1	pct 2
2	90	100
3	85	100
4	69	100
5	41	50
6	39	50
7	19	50

<tbody>
</tbody>

I'm having trouble using conditional formatting to highlight one column based on the value of another column in a table, values are formatted as percentage(no decimal) . The table above contains sample data. HOWEVER, the value listed in column "K" is the result of a formula. Here is what I need to accomplish:
IF J2 is <or= green
< or = (K2-10) fill J2 green
IF J2 is between (K2-11) and (K2-29) fill J2 yellow
IF J2 is >or= (K2-30) fill J2 red
apply to all of column J in the table

Does it matter that the data is formatted as a table?
Does it matter that there is already a formula in column K?

Any help would be appreciated.</or=>

 

[vxl21]

If Data in K if result of a formula, then excel calculates with exact decimals. May be in display you will get the rounded figure, but if you increase the decimals you will accept that your conditional formatting formula is right.

Keep the formula with =Round(formula,0) may help you to achieve the desired result. I did not try it. please check.