condition formula after 1 week word become red

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 ?

Originally Posted by ConneXionLost

Yes, just use the format painter (icon looks like a paint brush).

How can you apply it to other cells without it pointing back to the original cell?