Conditional formatting "stop if true"

[loki316]

Hi folks.

I am trying to conditionally format some cells and use the "stop if true" function but also keep any previously applied conditional formatting if possible, but i can't seem to do it.

I have a spreadsheet where Column A has dates in (we'll say the date a letter is due to be sent to somebody) and if those dates are over a certain time in the past (based on the current date/time) they highlight a certain colour. The more days we move on, the darker the colour gets to show it being more and more 'overdue' (hence I have several conditional format rules). Then I have a conditional format that strikes through the cell in column A once a date is input in the "completed" cell opposite in column B.

Once a date has been input in the completed cell in Column B and the strike-through applied to the cell in Column A, the cell in column A gets darker and darker each day as it is still applying the rules i have. I want it to stop applying the darker shades once the completed date is input, but i want it to keep the particular shade that had been applied up to the completed date being input (so i can keep track of how many items are overdue).

Is there a way this can be done?

Many thanks for any help given.

[FDibbins]

Of the top of my head, Im going to say no. Your rules are probably testing for x, y, z etc days past due, so no matter how you change that, it is probably still going to do that test.

Maybe upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[loki316]

Hi FDibbins, thanks for replying.

I've attached an edited sheet of what i'm working with. In the 'Letters' sheet, i have some conditional formatting that show some
letters are currently more overdue than others. Even after i enter a date in column H, the formatting in G takes place the more days
pass by. I want it to stop the formatting once i put a date in column H but to keep the colours of any 'overdue' letters in G so i
can see if we are getting them out on time or not (otherwise they all just end up showing as dark red once we are over 7 days from
the date in column G.

Hope that makes sense.

[JeteMc]

See if modifying/adding the following three conditional formatting rules helps.
For light gray fill with black text and strike through*: =AND($H9<>"",$H9-$G9<=0)
For pink fill with red text and strike through: =AND(H9<>"",H9-G9>0,H9-G9<=7)
For red fill with red text and strike through: =AND(H9<>"",H9-G9>7)
*This rule will require a 'stop if true' otherwise the text will be red for cells with dates less than 7 days old.
Let us know if you have any questions.