I need a Conditional Formatting formula to enter in "Use a formula to determine which cells to format" that looks at dates in Column B and highlights them if they are 90 days or more old if column F text is either "Investigating" or "Implementing."
This is the formula I currently have: = and($B2<=(today()-90),or($F2="investigating",$F2="implementing"))
It works to an extent but it highlights extra dates that are less than 90 days old and I am unsure why.
As an alternative, I am using the Conditional formatting: Format only cells that contain: Cell value - less than or equal to - =NOW()-90 because that is the ONLY formula I can get to work correctly on this date but it formats all cells that are 90 days or over old not just the ones based on column F that contain only "investigating" or "implementing."
Reply With Quote
