Cells to Watch for Negatives

Discuss the spreadsheet application

Cells to Watch for Negatives

Postby NotLeftBehind » Sun Jan 20, 2019 7:13 pm

I have a simple spreadsheet that adds and subtracts and shows me totals. Several random places are red negatives in the totals throughout the year of figures. For example:

DATE ADD SUB TOT
1/1____5_____0____5
1/2____0_____6___-1
2/1____10____0____9
3/2____0_____10___-1

In order to see all the figures of daily numbers for a year, I have to scroll to see if anything is in the negatives. Is there an easier way? Can I set up some cells (say at the top of my sheet where I always see F5, for example) to show/warn me of future (past current day/today) negatives at all in a column that goes way down a sheet?

Thanks.
OpenOffice 4 on XP and Vista
NotLeftBehind
 
Posts: 53
Joined: Mon Sep 23, 2013 3:57 am
Location: NC, USA, Earth, Sector 001

Re: Cells to Watch for Negatives

Postby Villeroy » Sun Jan 20, 2019 7:27 pm

=MIN(D2:D999) returns the smallest number in D2:D999
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26552
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Cells to Watch for Negatives

Postby RoryOF » Sun Jan 20, 2019 7:29 pm

Or set a conditional formatting in the column, so that if the value is negative, the background of that cell turns red.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28563
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests