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

Silver Contributor

Jan 23, 2020

Include Column C in your conditional formatting formula. Meanwhile, enter a formula in Column C to return either the text “FILL” or empty text (“”).

HNF5483

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)