Cells to Watch for Negatives

Discuss the spreadsheet application
Post Reply
NotLeftBehind
Posts: 67
Joined: Mon Sep 23, 2013 3:57 am
Location: NC, USA, Earth, Sector 001

Cells to Watch for Negatives

Post by NotLeftBehind »

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.
LibreOffice 7.4.4.2 (x64) on Windows 11 Pro
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Cells to Watch for Negatives

Post by Villeroy »

=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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cells to Watch for Negatives

Post by RoryOF »

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.15 on Xubuntu 22.04.4 LTS
Post Reply