Hello all,
I want to freeze conditional formatting of cell when month ends even if formula used in for conditional formatting returns false in next month.
Is there a way to do that? Please suggest.
Thank you in advance.
Hello all,
I want to freeze conditional formatting of cell when month ends even if formula used in for conditional formatting returns false in next month.
Is there a way to do that? Please suggest.
Thank you in advance.
Welcome to the forum.
You'd need to add a time clause to the formula used - what is the CF formula that you are currently using?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Formula i am using in Dec 2019 column for 1 assignment is:
=AND(TODAY()<$J$2,'3PFF Project Metrics'!$V$5="Pass-1 In Progress")
J2 is 1 Jan 2020, V5 is a status which will change to "completed" in January 2020. I want to keep status to "In Progress" in Dec column even if status will keep changing in next months.
Attach the workbook, please - instructions in the yellow banner at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks