![]() |
|
|
|
#1
|
|||
|
|||
|
In Cell C6 for daily amount, formula is D6/365 In Cell D6 for annual amount formula is C6*365
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Question re: Conditional formatting (cell occurs after another cell)
|
Saywarder | Excel | 1 | 04-20-2015 11:29 AM |
| Conditional Cell Formatting: Alternating Cell Checks | corbott | Excel | 4 | 12-16-2014 01:51 PM |
| Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
| Conditional formatting value change of same cell | tcalhoun | Excel | 0 | 04-25-2013 07:25 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |