Re: [libreoffice-users] Conditional Formatting On Date [SOLVED]

-------- Original Message  --------
From: Brian Barker
Date: Mon, 14 Sep 2015 06:15:32 +0100

> At 22:10 13/09/2015 +0200, Dave Barton wrote:
> > 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?
>
> I think you have (almost?) answered your own question.
>
> o Select *one* cell of your range - e.g. your A2.
> o Go to Format | Conditional Formatting... .
> o With "Condition 1" ticked, select "Formula is".
> o In the Cell Value Condition box, enter: WEEKDAY(A2;2)>5
> o For Cell Style, select Green. You need either already to have defined
> a "Green" cell style or else to create one on the fly using the New
> Style... button.
> o Now copy that formatting to other cells in your range. You can do this
> either by using the Format Paintbrush or by copying A2 and pasting it
> over the range, but using Paste Special... and selecting *just* Formats
> in the Paste Special dialogue.
>
> Alternatively there is a quite different technique using the STYLE()
> function. Modify your original formulae to read:
> =<your existing formula>+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green"))
>
> I trust this helps.
>
> Brian Barker

Yes, Thank you Brian. I knew where I wanted to go, but took a wrong turn
and got lost. I now have no idea why I missed the obvious.
Also, thanks for reminding me about the "+STYLE(IF" alternative.
Guess I was having a brain deadlock day. :(

Regards
Dave



-- 
To unsubscribe e-mail to: users+unsubscribe@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