| View previous topic :: View next topic |
| Author |
Message |
suppiblub
Newbie
Joined: 15 Apr 2006
Posts: 1
|
 Posted: Sat Apr 15, 2006 11:49 pm Post subject: deleted! |
 |
|
deleted!
Last edited by suppiblub on Fri Jan 18, 2008 12:20 pm; edited 1 time in total |
|
| Back to top |
|
 |
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Sun Apr 16, 2006 6:03 am Post subject: |
|
|
First set up a cell style
STYLIST open on CELL
right click on RESULT choose MODIFY
choose a background colour (and other formats that you may like)and check that the Number format is what you need, Time and date are fussy.
Cell A1 is the date
(in FORMAT/CONDITIONAL FORMATTING enter Cell value is less than TODAY() cell style RESULT
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
|
