| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if amount <0, put the all line in red
Try conditional formating for the row.
Click on the row number to format Select Format | Conditional Formating from the menu Switch from Cell Is to Formula in the drop down Add a formula like $A$1 < 0 The select the formating options you want. Hit ok and you should be in business. - John Michl www.johnmichl.com |
|
#2
|
|||
|
|||
|
sorry, it doesn't do the job -- doudou ------------------------------------------------------------------------ doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047 View this thread: http://www.excelforum.com/showthread...hreadid=399280 |
|
#3
|
|||
|
|||
|
Sorry I misread your request. The formula should be something like
= min($1:$1)<0 where 1 is the row number. Note that there should be no quotes in the formula. The first time you type it in, Excel may put quotes around it so you'll need to edit it to remove them. - John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
| Restrict input if amount is exceeded | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Linear Mode
