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?
Use conditional formatting with the following formula WEEKDAY(A2;2)>5
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
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!
Depending on the country settings, formulae either use ; or , as a separator. So the formula in cell
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.