| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Comment using Cell value as part of it
What I'm trying to do is the following:
if cell(a1) is different from 0(zero) then, cell(b1) should have a comment that say, the value of cell(c1) is the payment, next line the value of cell(a1) was refund, next line Total for today = cell(c1)-cell(a1) Example a1 = $10.00 c1 = $30.00 B1 (comment): $30.00 is the payment (c1) $10.00 was refund (a1) Total for today: $20.00 (c1-a1) can anyone help me on that? thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting & decimal part of a number in cell | Excel Worksheet Functions | |||
| Can Excel create a conditional Comment on a cell? | Excel Worksheet Functions | |||
| Conditional formatting for part of a cell | Excel Discussion (Misc queries) | |||
| Can I do conditional formula based on data in cell comment? | Excel Discussion (Misc queries) | |||
| Conditional Formatting - part of cell only | Excel Discussion (Misc queries) | |||
Threaded Mode
