Change cell color after n days

[antony]

Hi, All I normally just use open office writer but I need to create a spreadsheet with a members list on but I need the cell that certain members names are in to turn red after 28 days and some to turn red after 84 days and some never to turn red but I have no idea where to start so any help would be hugely appreciated

[Villeroy]

DateCategories.ods

(14.13 KiB) Downloaded 98 times

[FJCC]

You can do this with conditional formatting. First you need to enter the date that starts the countdown somewhere in the same row as the cell containing the member name. Let's say the name is in A3 and the date is in B3. After entering the date, select A3 and then go to the menu Format -> Conditional Formatting. Change the box that says Cell Value Is to Formula Is. Next to that, write the formula

Code: Select all

(TODAY() - B3) >= 28

Click the button that says New Style. Give the style a name on the Organizer tab and on the Background tab set the background to red. Click Ok until you are back to the main document.
You can copy this formatting to other cells that need to 28 day rule. Copy the cell as you normally would with CTRL + C or the menu Edit -> Copy. Select the cells you want to transfer the formatting to and then choose the menu Edit -> Paste Special. Choose to paste only the Formats.