Conditional Format
If Cell Value is MINIFS(Balance,Date,">="&TODAY())
Format: Outline
What I want is the minimum balance from today forward.
What it Outlines is minimum values before today’s date (which happen to be zeros)
Cells in range Date are formatted Date YY-MM-DD
Cells in range Balance formatted as Currency, negative in red.
What am missing? Thanks.
Budget2.ods (60.2 KB)
Youre »Date« are Text , not Dates, … any text is >= Today()
try to convert your Date-Column:
⇒ Data ⇒ Text in Columns ⇒ change the Column-type in the preview from »Standard« to »Date YMD«
No, Date are formatted as: Date: YY-MM-DD. And it doesn’t find $0.00 values AFTER TODAY(), just before TODAY().
And it doesn’t find negative values such as -$23.00 before TODAY()
The number format is as irrelevant as the color, font or border of a cell.
The format doesn’t matter, the cell content does. Is it a text string, or is it a “real” date? i.e. does the display string change if you apply a different format? It might also help to actually read the FAQ.
what shows ⇒ View ⇒ Value-Hightlighting: if the Dates are blue? ok … if the Dates are black? … not ok its Text!
Cleared direct formatting in all columns. Reformatted Balance as Currency and Dates as Dates YY-MM-DD.
So, there was some direct formatting. Oops. Lesson learned.
Now the Conditional finds/Outlines no cells, not $0.00, not negatives, nada.
Yes, except for dates which are stored as a serial number. I tried using DATEVALUE() but may have gotten that wrong.
I have worked with spreadsheets since VisiCalc, but I am somewhat new to LO Calc.
Upload your file for inspection. You may clean the other columns.
This may not be sufficient, as formatting don’t change types. So a string '01234 stays a string. Text-in-columns can convert this…
Budget2_pivot.ods (76.1 KB)
The conditional format matches at row 556.
The pivot table is a little extra, helping to analyze database-like data without touching the source table.
Yes, it is now working. Thanks for the tip.
Except the minimum Balance is in row 544, interestingly 13 rows above the actual minimum
Yes, it is now working. Thanks for the tip.
Villeroy
June 10(76.1 KB)
[
tjyPqO5hOfvQXt9IQnuy451Ae9S
OpenDocument Spreadsheet · 78 KB
](https://ask.libreoffice.org/uploads/short-url/tjyPqO5hOfvQXt9IQnuy451Ae9S.ods)
But that minimum is not >=TODAY()
there is a wrong »Text«-Date in Cell C547 !!
Yes, correct. I wrestled with it for a few days and forgot that Today() has move
My apologies, you are correct an I thank you! 
I got nearsighted.
Yes. I wrestled with a few days and got nearsighted.