formula in the "Refers to" box
apply the conditional formatting - formula:
The above method provides the means to set a conditional formatting to cells that contain formulas only. I am looking to do the opposite...for a specific set of cells I want to highlight them if they contain anything but a formula. This way the user will see right away if he overwrote the formula cell by accident. Is there away to modify the above method to do this, or is there a completely different approach to this?
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…