Forum Discussion

HNF5483's avatar
HNF5483
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 but I am having a hard time figuring out how to add text to the cell at the same time. 

 

Example1: Right now only Column B is highlighting 

But I want Column A to highlight and Column C to have "FILL" added to it and highlight. (See Example2) 

 this is the end result I am looking for.

 

I can get Column A to highlight along with Column B, where I am getting stuck is formatting column C to auto populate "Fill" and highlight at the same time.

If anyone can help I would appreciate it.

 

 

Charting
developer
excel
Formulas and Functions
Macros and VBA
office 365
training

13 Replies

  • Twifoo's avatar
    Twifoo
    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's avatar
      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's avatar
        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.

Resources