Thread: Countif - change color of cells that meet criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
  
Posts: 390
Default 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-
Reply With QuoteReply With Quote