Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - change color of cells that meet criteria
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . . ." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Consecutive Cells that meet Criteria | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions |