Change color of row when criteria is met

How do I set up a row to change to gray once the status is marked closed?

Answers

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭

    Hi @Jenn123

    You can use conditional formatting to change the row color based on Status.

    Isis Taylor

    Business Analyst Senior

  • You can use conditional formatting to change the cell color based on the status. For instance, choose the status column is not blank for your condition, then choose the highlight color as grey for your format and choose entire row or selected cells for the range

    I use this all the time to color code completed cells, cells at risk, cells overdue, etc.