I hope to get Some help. I am Stuck on a condition. Let me explain it.

1. There is Col"L" in sheet which is AGE and all conditions (Formulas) are lies on the AGE. Whenever any data is pasted in the the Sheet Including AGE then Col"P" is highlights in Pink Color (Pink means "Pending") and Column "AP" creates a NOTE like this HEDAL - COM? TH - 12-03-2021.

2. If i mention the Date in Col"P" in Pink color then it gets Green and NOTE becomes like this HEDAL - 2021 COMPLETE - TH - 12-03-2021

3. I want If i mention "J" in highlighted cell of Col"P" then it should create Same NOTE as Pink Color has. That means if Cell is Pink or has "P" then it NOTE should be this HEDAL - COM? TO - 12-03-2021

If it has Date it would be like this HEDAL - 2021 COMPLETE - TH - 12-03-2021`

If it has nothing then it should be empty.

It is must to have Col"C" and Col"I" in the NOTE formula.

Your help will be appreciated.

Note:

• Combined the conditions in the first if statement since the first 2 can be combined (they have the same conditions) and have added an OR to combine it again with the J value in column P.
• GETBACKGROUNDCOLOR is used to check if a certain cell has white color (e.g. #ffffff). If it is white, then return blank. If it is not white and does not satisfy the earlier conditions, then proceed with "COMPLETE"