Countif - change color of cells that meet criteria
 

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

Countif - change color of cells that meet criteria
 

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


" wrote:

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

Countif - change color of cells that meet criteria
 

In .com,
spake thusly:

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")

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-

Countif - change color of cells that meet criteria
 

In , Dallman Ross <dman@localhost.
spake thusly:

Find -- put that formula in the Conditional Formatting area and

Meant to type: "Fine -- put that formula . . ."