Forum Discussion

Deleted's avatar
Deleted
Jan 24, 2018

Excel Conditional Formatting

When the condition is met in a cell I need the entire row to format. Any ideas?

  • Tanya Denton's avatar
    Tanya Denton
    Steel Contributor

    Highlight your table.  In my example i am looking for 2014 in column P and then highlighting that row.  Hope this helps

     

    • Deleted's avatar
      Deleted

      I am struggling to create the formula. This is what I need. If column V =Approved then highlight entire row. then repeat for Pending and Completed with different formats. All based on the answer in Column V.

      • Tanya Denton's avatar
        Tanya Denton
        Steel Contributor

        Create a Rule for each condition (i.e =Completed, = Pending etc..)

         

Resources