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...

Attached Files

Excel_Conditional Format_Filter Due Warning_1,2,3.xlsx (11.8 KB, 3 views)

Hi, it looks like you have the conditional formatting for the yellow (less than or equal to 118 days' difference between original date and today) and the red (greater than 126 days' difference between those dates.) Note that I used greater than or equal to 117 days, not 118, because I presumed your third category would cover 118 days in the green condition.

Where I appear to have messed up is I also have overlapping conditional formats on 126 days. The red formula should have > 126, not >= 126. So if it's exactly 126 days it still falls in the green, if I understood what you wanted.

All you really have to do is emulate the formula I had for the green condition, which in the case of this new file would be

Thank you for the assistance. Does this represent what you mentioned above for Test #1 of this new workbook sheet? attached....

Attached Images

Screen Shot 2023-04-05 at 2.49.10 PM.png (58.9 KB, 14 views)

As far as I can see, yes. That formula is wider than what is displayed there.

The important factor is, does it actually work?

Try plugging in different dates in the original date field (M2).

Exactly 120 days ago today (6-Apr) would be 7-Dec-2022.

116 days ago would be 11-Dec, and 126 days ago 1-Dec. So 127 days ago would be 30-Nov-22.

If you put in those dates you should see the various results expected.

Thank you so much. I input various dates as you suggested, and now have both Test 1 and Test 2 scenarios working, even with changing the basic rule... I'm learning... Now another "Q" regarding Test #3, ICON SETS "Street Lights" in cell V23. How could I apply the same rules to this version (Test#3)?
Thanks... K...

Attached Images

Screen Shot 2023-04-06 at 9.35.36 AM.png (43.3 KB, 11 views)