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.