Color change on format rule for one week

[faraaz]

Hi All,

I need suggestion, How to set format rule for a period of time.

Ex:- I have a table which list the percentage of some progress. When the progress is 100%, I want to color GREEN for a week. I gave an expression which make the data GREEN color if the value is above 0.99 but how can I show color or format rule to be applicable for one week only ?

Please let me know.

Thanks,
Faraaz Shaik