Conditional format/Formula issue

[Newbienew]

Good day, all.

The issues that I am having deals with conditional formatting overall but is two parts. On my rolling app log page (Orange) I constantly add new info and have to sort it and then delete the rows that are not needed anymore. This results in two issues for me.

• My conditional format starts to break up instead of maintaining F:F. I will get F1:F12, F13:F89 for example. I have to go in and correct this every time so I don’t have a lot of these.
• The formula on the job sheet the true or false that is returned becomes a #ref! under both the T and Z Columns. Which if not corrected throws off the orange sheet, in which I have to go and click the quick fill to get it working every time.

Is there a way to prevent these two issues from happening?


Projects

 

[Newbienew]

? Anyone

 

[Newbienew]

????