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