Countif - want to change color of cells that meet criteria 1

[coolkake]

Hey All

I've got a simple countif and all I want to do is change the cell color on the items that fall into this criteria. For some reason I can't figure out how to make this happen ;(
Here's my countif
=COUNTIF(I:I,"<=29")

Thanks in advance
Kake

 

[dallen43]

Select the cells for the formatting.
Select Format and Conditional Formatting.
Change "Cell Value is" to "Formula Is" and enter the formula.
Then click format, pattern tab and select your color.
Click OK twice.

Your formula will color a cell if any cell in column I is less than or equal to 29.

If you wanted any cell that is less than or equal to 29 in column I to be highlighted, use the "Cell Value Is" in Conditional Formatting.

Hope this helps,
Deb

 

[coolkake]

Thank You, Thank You, Thank You
God do I love this site