SoftMaker.com

Sub ResetCellsToZeroWithLetters
Dim c As Object

' grams
For Each c In ActiveSheet.Range("Y9:Y11,Y13:Y18")
c.Value = "0g"
Next

' plain zero
For Each c In ActiveSheet.Range("Y2,Y6,Z9:Z23")
c.Value = "0"
Next

' milligrams
For Each c In ActiveSheet.Range("Y12,Y20:Y23")
c.Value = "0mg ...

Thank you miguel-c. I guess I have a lot to learn about formulas.

Oh crap, sorry. Here is the file unprotected.

Sorry if this sounds like a stupid question to most of you but I have searched the internet and have not been able to find the solution to my question not to mention I am new to creating formulas and trying to learn.

I have a column of percentages and each row (a different day) are calculated daily ...

Does anyone know how to total cells based on the font color for the cells?
Thanks in advance.

I am currently using Softmaker FreeOffice. Do I need to purchase the full version or the upgrade version for the SoftMaker Office Professional 2021?