| 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 |
| 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) | |||
Threaded Mode
