Difference Between Matching Columns, Average Formula Inc. Text & Highlighting Number Value

Hello All,

Today I am trying to get a few things sorted out. And I know many of you are really knowledgeable and love helping... SO;

The first issue is:
I need help with a formula that is on Sheet!ThisMonth, in columns D2:D4 to look at last months columns Sheet!LastMonth D2:D4 LOOKING AT THE EMPLOYEE NUMBER ONLY, not the names. To then look at both the Sheet!ThisMonth and Sheet!LastMonth C2:C4 values and have the difference.

Secondly:
I also need to get the Average percentage in E1 to be similar to AVG: 52.9% but whenever I try
="AVG: "&AVERAGE(C2:C4) it comes up as: "AVG: 0.529"
It is shifting the decimal over and dropping of the percentage. Now I can just add a &"%" on the end but this doesn't solve my decimal problem, It's still "AVG: 0.529%"

And Lastly:
If there's blanks in any of the cells in B2:D2 I would like for B1 to be highlighted red. If all cells have a number value in them, I would like for it to be highlighted green


I know it's a lot I apologize, but anything you guys can help out with would be GREATLY appreciated! Thank you in advance!

Easy one for now:

Formula:

="AVG: "& TEXT(AVERAGE(C2:C4), "0.0%")

Or:

Formula:

="AVG: "&AVERAGE(C2:C4)*100 &"%"

Microsoft Excel 2022

1. There is no such version - do you have Excel 2021 or Excel 365? Please update your profile accordingly.

2. For future reference, please note that your thread titles should NOT be generic (see our rules). I will change it for you this time, but pleae take more care over this in future. Thanks.