Am 13.09.2015 um 22:10 schrieb Dave Barton: > In Calc I have column with a series of calculated dates (ie. the result > of a formula). I am looking to find a way of using conditional > formatting to set the background colour (eg. green) for those dates > which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5 > sets Format: Cell Background = Green) > Can anyone offer any pointers to a solution? > TIA > Dave > > >
Try =ISTEXT(A2) first. -- 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
