Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"making" a line red.
Can I make a whole line go red, if one column gets a higner number then 26.
That one column add´s up 3 others and when it hits 27, I want it to make the whole line red. Is that possible? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"making" a line red.
Select the whole row, and use conditional formatting, with a condition of
Formula Is, and a formula of say =$H326 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "CR" wrote in message ... Can I make a whole line go red, if one column gets a higner number then 26. That one column add´s up 3 others and when it hits 27, I want it to make the whole line red. Is that possible? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
"making" a line red.
CR wrote:
Can I make a whole line go red, if one column gets a higner number then 26. That one column add´s up 3 others and when it hits 27, I want it to make the whole line red. Is that possible? Hi CR, You can use Conditional Formatting. First of all, select the line to format, then from menu Format, Conditional Formatting select "Formula is" under Condtion 1, then type in the text box a function like this: =$A426 and then click on Format and chose your format. In the above formula I assume that the cell in which you are summing is A4. Be aware of the "$": if your line to be red is a row, then the right formula is that above; if, instead, the line to be red is a column, you should use: =A$426 -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
Data showing incorrectly on line chart | Charts and Charting in Excel | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |