Forum Discussion

RachelEM's avatar
RachelEM
Copper Contributor
Apr 22, 2020
Solved

How to carry conditional formatting down from row to row

I am trying to format a column based on the conditional formatting in another column.  I have Year Built in column I.  When a cell in column I is less than 1978, it highlights the cell pink.    Now...
Excel for web
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 22, 2020

RachelEM 

You may apply the rule to both columns as

I didn't check it with Excel Online.

  • RachelEM's avatar
    RachelEM
    Copper Contributor
    Apr 23, 2020

    One more question, please SergeiBaklan.  I would like to again format a column based on another column.  When I put a date paid in the other column, I want to highlight my cell to trigger for follow up.  Once I put in a yes or n/a in my current cell, I want the highlighting turn turn off.  I've tried a number of combinations using If/And combinations with Null/Blank/>0, but nothing I've tried so far is working.  Here's my current formula.  I'm sure it's something simple to fix it, but I can't quite figure it out.  Any help is appreciated! 

     

    ="IFS($S$3ismm/dd/yy,$V$3Is("yes"OR"n/a"))"

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 24, 2020

      RachelEM 

      That could be like

      with formula

      • RachelEM's avatar
        RachelEM
        Copper Contributor
        Apr 24, 2020

        Thanks, SergeiBaklan.  Here's my formula:  =($S$3>1)*($V$3<>"yes")*($V$3<>"n/a").  This one isn't working this time.  Any other ideas?  🙂

  • RachelEM's avatar
    RachelEM
    Copper Contributor
    Apr 23, 2020
    Awesome. That worked, thank you very much!

Resources