title: How to Conditionally format HTML TABLE in SQL SP
body: <p>I created a SP to monitor SQL Server Agent Jobs and generating Email for the same in HTML Format.
  However, I want to conditionally format the Run Status column to be Red/Green based on cell value(TEXT-Success/Fail).
  Please find the code at <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2663e23b-0b55-4816-beb8-fdf8a020396d/formating-msdbdbospsenddbmail?forum=transactsql" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2663e23b-0b55-4816-beb8-fdf8a020396d/formating-msdbdbospsenddbmail?forum=transactsql</a> 
  (Marked Answer by Hilary Cotter(MCC, MVP))</p>
  
  <p>Kindly help me with the missing code to implement this feature.</p>
  
  <p>Thank You.</p>