Quote:
Originally Posted by kilroyscarnival
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.
|
Hi.... I picked that up about the FORMULATEXT, in that it was a nice add on but not typically required.
Still work on it with what you provided. I have created a new worksheet with the noted parameters that we were talking about. Perhaps this clean sheet is best... can you give me any suggestion for the 3 test conditions. I would then play around with them to see what works best. Thanks..
K...