I have never tried conditional formatting, but, it may apply, sorry I don't have time to investigate further, but, hopefully it helps.
https://help.libreoffice.org/Calc/Conditional_Formatting On 09/05/2014 11:04 PM, Ross wrote:
I have a spreadsheet to keep track of payments. In one column I will type 'ctrl+;' to enter the date. These cells are formatted for date and duly show the date. If a date is entered the amount received will appear in the adjacent cell (the amount is the same for everyone, so it's part of the cell formula). On a separate sheet I keep track of payments due. These cells check for entries in the 'Date' column. If the 'Date' column cell is blank, they show amount due (requiring 'number/currency' formatting); if there is an entry in the 'Date' column cell (ie. there has been a payment) I want the cell to show the date from the 'Date' column. However, because the cells are formatted for 'number/currency' I get a number. Under formulas we have dateValue(). What is the opposite of that? Why isn't there a dateText() formula? What am I missing? -- View this message in context: http://nabble.documentfoundation.org/dateValue-to-dateText-tp4121333.html Sent from the Users mailing list archive at Nabble.com.
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
