Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, all are positive.
Is there a way, I can fill the cells with a color, if they are
greater than 30, for example. Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, all are positive.
Have a look in Help under the topic Conditional Formatting
Gord On Sun, 16 Oct 2011 07:18:48 -0700 (PDT), Skip wrote: Is there a way, I can fill the cells with a color, if they are greater than 30, for example. Thanks for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, all are positive.
On Oct 16, 10:18*am, Skip wrote:
Is there a way, I can fill the cells with a color, if they are greater than 30, for example. Thanks for any help. See Conditional Formatting in Excel Help or: http://www.contextures.com/xlCondFormat01.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, all are positive.
On 10/16/2011 at 9:18:48 AM Skip wrote:
Is there a way, I can fill the cells with a color, if they are greater than 30, for example. Thanks for any help. These instructions work for Excel 2007: * Highlight all the cells that have values in them * Within the Home tab, select the Conditional Formatting icon * Select Highlight Cells Rules * Select Greater Than * Insert the value 30 in the Format Cells That Are GREATER THAN cell * Pull down the menu on the right side and chose according to your desires. -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a column of numbers, some positive, some negative. | Excel Worksheet Functions | |||
How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
column of negative numbers into positive numbers | Excel Worksheet Functions | |||
add only positive numbers and avg in a column | Excel Worksheet Functions |