LinkBack URL
About LinkBacks
i need a condition formula that will automatic change the date to red colour when it over 1 week, example today is 22/11/10, if the cell have date 15/11/10 and below will become red colour.
thanks
i need a condition formula that will automatic change the date to red colour when it over 1 week, example today is 22/11/10, if the cell have date 15/11/10 and below will become red colour.
thanks
Last edited by choy96; 11-21-2010 at 11:45 PM.
Hi,
Use the 'formula is' option in conditional formatting and enter
and set the pattern colour to red.
=TODAY()-A1>=7
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks very much Richard Buttery.
if the cell already have the date and conditional format have not put in yet, can i paste the conditional format into the cell only without change the date ?
Yes, just use the format painter (icon looks like a paint brush).
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
How can you apply it to other cells without it pointing back to the original cell?Originally Posted by ConneXionLost
Use relative references in the formula (instead of absolute references).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks