Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to change the color
of a row of values, depending upon the value of a single cell.
I have 400 rows of data. I would like to change the row color, if the value of a cell in each row is for example less than 3. Is there a way to do this using a formula? I appreciate any help. Skip |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to change the color
Check out Help on Conditional Formatting.
If you need more help, post back with some specifics like Is the single cell in each row in the same column? How much of each row do you want colored? Entire row or just maybe columns A to M? Gord Dibben MS Excel MVP On Sun, 5 Jun 2011 05:48:13 -0700 (PDT), Skip wrote: of a row of values, depending upon the value of a single cell. I have 400 rows of data. I would like to change the row color, if the value of a cell in each row is for example less than 3. Is there a way to do this using a formula? I appreciate any help. Skip |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to change the color
If you need more help, post back with some specifics like Is the single cell in each row in the same column? YES How much of each row do you want colored? Entire row or just maybe columns A to M? A to O |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to change the color
Assuming column A is where your single cell in each row is located.
Select A1:O400 In 2003............FormatConditional FormatCondition1Formula is: =$A1<3 exactly as I have typed it. The $ sign is important. If not column A, adjust to suit. Format to a color of your choice and OK. In 2007...........Home TabStylesConditional FormattingNew Rule Pick "Use a formula" and enter as above Gord On Sun, 5 Jun 2011 15:16:41 -0700 (PDT), Skip wrote: If you need more help, post back with some specifics like Is the single cell in each row in the same column? YES How much of each row do you want colored? Entire row or just maybe columns A to M? A to O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |