Lotto.ods <http://nabble.documentfoundation.org/file/n4096842/Lotto.ods>
Brian and other interested folk Thanks for the formula! I am going to need a few days to see how it works, but it certainly has promise, however I cannot see the different sheets that the ods file contains. Remember: There is one sheet for the tickets purchased, another sheet for the draw results. The background colour of a number on the tickets sheet is going to change colour if it is the same as any number shown on the corresponding date of the draw sheet. Have a look at the file attached via Nabble for a better view, and no misunderstandings. Ascertain if on a certain date on the Tickets sheet, on the same date in the corresponding draw sheet, if any of the numbers match. If so colour the cell background of each matching number on that same date via conditional formatting. Example with fictitious data: Ticket sheet 01/02/2014 02 05 07 35 37 39 Draw sheet 01/02/2014 37 07 09 35 05 16 Therefore the cells on the Ticket sheet holding the numbers 07, 35, 05 would have a background colour that is not white :) If the 6th number on the ticket and in the draw is the same the cell background needs to be a different colour to the others. This indicates to me that I have won some cash. Hopefully this clarifies matters a bit and hope others can use the attachment. -- View this message in context: http://nabble.documentfoundation.org/Calc-Searching-for-values-in-a-certain-range-string-tp4096215p4096842.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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