Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a IF formula result to underline a row?
Can I make a formula that basically says, for example, IF A2 does not equal
A1, then underline row A1. Thanks for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a IF formula result to underline a row?
Formulas in cells don't do this kind of thing.
But you can use format|conditional formatting (xl2003 menus) to do what you want. Select A1 Format|Conditional formatting Formula is: =A1<A2 And choose a nice underline (single or double) on the formatting dialog. Todd-o wrote: Can I make a formula that basically says, for example, IF A2 does not equal A1, then underline row A1. Thanks for any help! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a IF formula result to underline a row?
hi
not with a fomula. formulas return values to the cell in which they reside. they can not perform actions such as underline data in another cell. you might have better luck with conditional formating. high light the row or as much of it as you wish. i recomend just the data and not the entire row. formula is.......=$A$1<$A$2......format font underline. regards FSt1 "Todd-o" wrote: Can I make a formula that basically says, for example, IF A2 does not equal A1, then underline row A1. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for if result is friday, make it thursday. | Excel Worksheet Functions | |||
If the result of a formula is negative make equal to zero | New Users to Excel | |||
Make the result of a formula red (cannot be done in cond. format.) | Excel Discussion (Misc queries) | |||
Borders nor underline commands remove an unusual underline. ?? | Excel Discussion (Misc queries) | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions |