openoffice calc conditional formatting more than 3

You must have at least the following items in your spreadsheet.The style is up to you, since this is your budget! You will be generating the same type of spreadsheet with different numbers and different entries.This is an example of what your final spreadsheet may look like. Your file must be uploaded to Canvas by the due date.These directions will assume you are using Microsoft Excel.OpenOffice Calc or LibreOffice Calc (.ods) are acceptable free alternatives. Your assignment should be saved as a Microsoft Excel document (.xls or.This assignment will be out of 1000 possible points. Now the dates are formatted the way you desire.You will generate a Microsoft Excel spreadsheet showing your monthly financial budget. In Paste Special dialog, pick Format only for paste, unselect all others, press ok.Use Paste Special function (right mouse click or Edit on menu).Copy contents of cell in sheet view using Ctrl-c.Accept conditional formatting, close dialog.Pick/edit the style with the background to suit.Next to the Formula dropdown selector, enter the formula: WEEKDAY(A1 2) Select from the dropdown list in the formatting dialog box, Formula.Select the first cell in the list of dates ( A1).The following steps will succeed in reproducing finished product: Conditional formatting documentation here.Īs explained by these steps can be consolidated by using a conditional formatting Formula from the dropdown list. Then, apply Conditional Formatting on the new column, every value less than or equal to 5, have that be your weekday color, add another style and condition for greater than 5, that will be your weekend color. The documentation for the function is here. In a separate column, run the formula =WEEKDAY(A1 2).

Openoffice calc conditional formatting more than 3