Countif - change color of cells that meet criteria

K

kake

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
 
R

Ron Coderre

Try this:

Select the Col_I cells

From the Excel main menu:
<format><conditional formatting>
Cell value is: Less than or equal to 29
Click the [format] button and set the format you want
Click the [OK] buttons to finish

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
D

Dallman Ross

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")
Click to expand...

Find -- put that formula in the Conditional Formatting area
and select "Formula Is" rather than "Cell Value Is".
But are you sure the formula is right? If there is one cell or
more in Column I that is <=29, the formula evaluates to TRUE
and the condition will be applied. Maybe you mean to write
just =I2<=29 for the conditional format for Row 2 of whatever
column you're in?

-dman-
 
Top