Quote:
Originally Posted by Kwmck328
Thank you again. Working on it... FORMULATEXT is a new one for me... I will use the rest of the week to get and understanding and its use... very nice.
I will get back to you.
K..
|
Oh, I only used FORMULATEXT in order for it to display the formula in the cell next to it. It's handy for that.
It's really the conditional formatting you could look at. I did a screen shot and pasted it in there so you could see all the steps working at once. Try changing the initial date to October 1, 2022 and January 30, 2023 and yesterday.