Hi all,
I want to highlight a full row (at least the part that has data in it) when a date goes 60, 120 and 240 months from today. Also, how can I take a balance and use it in another column once that maturity is reached?
Hi all,
I want to highlight a full row (at least the part that has data in it) when a date goes 60, 120 and 240 months from today. Also, how can I take a balance and use it in another column once that maturity is reached?
Hi, and welcome to the forum.
It's not entirely clear. If a row is highlighted because a date (presumably in a specific cell) is 60 months from today then why specify 120 & 240 months as well. Do you mean >= 60 months. Or do you only want to highlight the row if the dates are exactly 60, 120 or 240 days hence but not say 61 dates hence?b
To use the balance just use an IF function in the cell in which you want to see the balance. e.g.
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks