Formula help between sheets

[eileen123]

Hello, I need help with a formula between sheets as well. The 1st sheet needs to be linked to the 2nd sheet and if any entry ("*") is made in a specified cell (not a range) in the 2nd sheet, then I want the result to populate in the first sheet as "Y" and turn the cell background to turn green (conditional formatting). If the 2nd sheet has no entry - I want the result in the 1st sheet a "N" and the cell background to turn red.

1st Sheet:

2nd sheet Goal

2nd Sheet KPA's (if anything is completed in a range of cells:

The first sheet is an accountability tracker to show which students have completed their weekly updates for goals and KPA's. The KPA's results would be a range.
Thanks in advance for any help.

 

[Larry Haydn]

Unable to see your images.
Can you post again?

 

[eileen123]

Reposting with images:
Hello, I need help with a formula between sheets as well. The 1st sheet needs to be linked to the 2nd sheet and if any entry ("*") is made in a specified cell (not a range) in the 2nd sheet, then I want the result to populate in the first sheet as "Y" and turn the cell background to turn green (conditional formatting). If the 2nd sheet has no entry - I want the result in the 1st sheet a "N" and the cell background to turn red.





2nd Sheet KPA's (if anything is completed in a range of cells:

The first sheet is an accountability tracker to show which students have completed their weekly updates for goals and KPA's. The KPA's results would be a range.
.

2nd Sheet Goal by date:


2nd Sheet KPA's (if anything is completed in a range of cells:


The first sheet is an accountability tracker to show which students have completed their weekly updates for Goals and KPA's. The KPA's results would be a range.
Thanks in advance for any help.

 

[Larry Haydn]

It appears that your focus is on the KPAs.

For the KPA cell, you can either:
* have a formula to count the number of "Yes" in the second sheet KPAs, or
* check the value of the weekly Total Done

Here are the formulae:

Hope this answers your question.

 

[eileen123]

Thank you. I don't think I explained it very well, so not the answer I was looking for.

Thanks or your time.