Someone else designed a spreadsheet for me to input data that they need; most rows are straightforward: July numbers come in and get typed into the July column for their row. But a couple of them are aggregates: I’ll get one part of the final number on Tuesday and a different component of it on Thursday, or whatever. So I’ll end up typing in the first number on Tuesday; the cell is now occupied, and to the eyeball looks like data is complete. But it isn’t. On Thursday I stick an = sign in front of Tuesday’s number then append a “+” and then Thursday’s number, so it’s a formula.
Any way I can make that cell be (for example) purple if it contains a raw number but yellow if it contains a formula adding two numbers together?
The FORMULATEXT() function returns the text of a formula if the cell contains a formula, or the #NA status if the cell contains a value. Test for that with ISNA and Robert is probably your mom’s brother.
I"ve gone to Home / Conditional Formatting. “Use a formula to define which cells to format”. Defined this as the formula:
ISNA(FormulaText(f:21))
where F21 is the test cell. Told it to make the cell cranberry pink under those circumstances.
Cell does not turn cranberry pink when cell contains =32+75 nor when cell contains raw number 113 instead.
If I change the formula to =ISNA(FormulaText(f:21)) it complains that it isn’t an appropriate/valid formula and won’t let me okay it.
What am I not doing that I’m supposed to do?
ISFORMULA() is easier to use than FORMULATEXT(). And get rid of the colon between the column and row, and add an equal sign at the start.
=ISFORMULA(A2)