Forum Discussion
What am I missing?
I am trying to create a spreadsheet that will automatically highlight and fill in specific cells, when a value is added to another cell. I have conditionally formatted the correct cell to highlight b...
You may construct your formula in C1 like this:
=REPT(“FILL”,
B1>0)
=REPT(“FILL”,
B1>0)
I tried =REPT(“FILL”,B4>0) and I get this error.
I keep running into this and it asks me to change the formula.
- The formula is B1>0, not B4>0. Anyway, that formula is equivalent to this, which you may try in C1:
=IF(B1>0,”FILL”,””)
