First time here? Check out the FAQ!
asked 2012-08-17 02:00:37 +0200Tech.CG
I would like to set some cells that contain a date to change their font, color, font styles, etc... when the date +6 months has been reached.
If I set the date in the cell to 8/16/12, then in 6 months from now, I want the date to change to look like 8/16/12 or similar.
Thanks in advance.
answered 2012-08-17 15:25:56 +0200w_whalley
You can do this with conditional formatting.
In the target cell choose Format/Conditional Formatting. Set the condition as "Formula is" and make the formula
TODAY()>41322 where the number 41322 is the date 6 months from now expressed as a number. Create a new style as the cell style with the properties you want (e.g. bold, italics). When the formula evaluates true (6 months from now) the new format will be displayed.
You can get the number corresponding to the future date by typing the date in a cell then changing the format of the cell to Number.
answered 2012-08-17 20:58:45 +0200mariosv
If you need an automatic formula: CellReference < EOMONTH(TODAY();-6)
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-17 02:00:37 +0200
Seen: 534 times
Last updated: Aug 17 '12