Dears,
A daily sum of values from several columns is to added to a basal negative number that each day increases by this sum up.
when this basal number approaches zero a blink or alert message is opened in the box.
Please see attached file
thanx
Dears,
A daily sum of values from several columns is to added to a basal negative number that each day increases by this sum up.
when this basal number approaches zero a blink or alert message is opened in the box.
Please see attached file
thanx
Hi,
One way would be to add a SUM formula to L3 and use a conditional format to paint it say red when it approaches zero. Of course you'll need to define what youj mean by 'approaches'.
So use a simple
Formula:Please Login or Register to view this content.
and then a conditional format set to fill the cell with red
Formula:Please Login or Register to view this content.
this will show red when the number is larger than -20.
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.
But Richard
1. I want the cell gives a text message when it becomes zero or more.
2. the count starts from the beginning the day after it reached zero.
thanx
Another way is by using vba code. Please find the attached sheet to see if this works as per your requirement.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
I changed my mind about answering this.
Last edited by newdoverman; 04-15-2014 at 03:08 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks