| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF number is grather than 100 color the cell red
I did this before but I can't remember how I did it. I want to have a
column of numbers and if they are greater than a certain value ie: 120 , I want the sell to have the color red. Any ideas how to do this in Excel 2007? THanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IF number is grather than 100 color the cell red
Take a look at format|conditional formatting.
Ron Boetger wrote: I did this before but I can't remember how I did it. I want to have a column of numbers and if they are greater than a certain value ie: 120 , I want the sell to have the color red. Any ideas how to do this in Excel 2007? THanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
IF number is grather than 100 color the cell red
That did it!
Many Thanks On Thu, 09 Aug 2007 19:36:11 -0400, Ron Boetger wrote: I did this before but I can't remember how I did it. I want to have a column of numbers and if they are greater than a certain value ie: 120 , I want the sell to have the color red. Any ideas how to do this in Excel 2007? THanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell color if it is the lowest number of a group? | Excel Discussion (Misc queries) | |||
| How Can i change the Color of a Cell Based on Number Value (-/+)? | Excel Discussion (Misc queries) | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
Linear Mode
