Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list with dates in it, and I would like to mark the dates representing weekends as red (for easier telling which day of the week it is without having to manually look up the day of the week at the left, and just for extra emphasis). There's no option in the Format Cells dialog to do this, though (although there is an option to mark negative numbers red in the Number format). How could I go about doing this manually?

share|improve this question
up vote 2 down vote accepted

Use conditional formatting with the following formula WEEKDAY(A2;2)>5

enter image description here

You can use this format in all cells Monday-Sunday and only the weekends will be highlighted. In this example I highlight the cell ABOVE the actual date. You can format muliple cells in a column by "fixing" the cell from which you get the date: WEEKDAY(A$2;2)>5 (WEEKDAY(A$2,2)>5). As you can see, I use the same for the current date (in cell DX2) where the current date is coloured blue.

Important 1:

I have experienced a lot of conditional format problems in LibreOffice, especially that the conditional formats don't "stick" and 80% is lost after you saved and then re-opened the file. Switching over to OpenOffice completely resolved that issue for me!

Important 2:

Depending on the country settings, formulae either use ; or , as a separator. So the formula in cell A1 could also be: WEEKDAY(A$2,2)>5

share|improve this answer
@Joe Have you tried the automatic solution presented above? – Robert Ilbrink Mar 19 '13 at 11:29
@joe Please provide feedback on the proposed solutions. When an answer was helpful, please "Accept" that answer by clicking on the WHITE "Check-mark" next to the answer, to turn it GREEN. Thank you! Clicking the check-mark will give credits to the person who submitted the answer and will mark the question as answered. See: Accepting answers – Robert Ilbrink Mar 21 '13 at 2:13
@JoeZeng Please give feedback and if the proposed solution was helpful,"Accept" the answer! – Robert Ilbrink Mar 22 '13 at 9:28
Oh, sorry, I forgot to check back on this question. – Joe Z. Dec 11 '13 at 2:32

To change the font color. Right click the cell and select format cells, then choose font effects and select your font color there. If you want the cell to be red do the same as above except choose background instead of font effects to change the color of the cell.

share|improve this answer
No, I'm talking about having the date be automatically red if it's a weekend. – Joe Z. Mar 18 '13 at 14:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .