Please help me.....
I am looking to condition format an array of date cells that go down vertically in a table and I want to condition format the cell when it reaches pass the 20th, which is the deadline e.g. receive document on 1/2/11, meaning the deadline date falls on 21/2/11. Once one day over e.g. 22/2/11 the cell should go read for example. How can I implement this.
As always people knowledge is very much appreciated and valued.
J
I am looking to condition format an array of date cells that go down vertically in a table and I want to condition format the cell when it reaches pass the 20th, which is the deadline e.g. receive document on 1/2/11, meaning the deadline date falls on 21/2/11. Once one day over e.g. 22/2/11 the cell should go read for example. How can I implement this.
As always people knowledge is very much appreciated and valued.
J
