Forum Discussion

Copper Contributor

Jan 23, 2020

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...

Charting

developer

excel

Formulas and Functions

Copper Contributor

Jan 23, 2020

Thank you! I will do that for the highlight- Do you have a good formula for the "Fill" - I can't seen to find the right one that will work. Twifoo

Twifoo

Silver Contributor

Jan 23, 2020

What condition do you want to be fulfilled so that the text “FILL” will be returned in Column C.

HNF5483
Copper Contributor
Jan 23, 2020
When a percentage is entered into a cell in Column B, is when I want Column C to add "Fill" to that cell number Twifoo
- Twifoo
  Silver Contributor
  Jan 23, 2020
  You may construct your formula in C1 like this:
  =REPT(“FILL”,
  B1>0)
  - HNF5483
    Copper Contributor
    Jan 23, 2020
    I tried =REPT(“FILL”,B4>0) and I get this error.
    I keep running into this and it asks me to change the formula.
    
    Twifoo