Function by Color FAQ

Questions about calculating cells by color.

Does it recalculate automatically when I only change a color?

No. Formatting-only changes do not reliably trigger recalculation in Google Sheets. Use Refresh and the add-on reads the live range again.

Does Preview change my Sheet?

No. Preview reads the source range and returns a compact result. It does not write to the source.

What does Insert change?

Insert writes the calculated result to exactly one destination cell that you selected outside the source range, then reads it back to verify the write.

What is included in Free?

SUM and COUNT by background color, one saved calculation, Preview, Refresh and verified result insertion.

What does Pro add?

11 additional calculations for 13 total, font-color calculations and up to 20 saved calculations.

Does a saved calculation store my cell contents?

No. Saved setups store only workbook/range references and operation/color metadata needed to reload the setup.

How much is Pro?

Pro is $2.99 per month or $29 per year after the seven-day full Pro trial.

Want the exact plan differences?

Function by Color launches with only Free and Pro as public plans.

View pricing