title: Color in cell containing a string Pandas
body: <p>i am trying to change the background color in my dataframe if a column contains a certain string however i cant seem to get it to work. I have the following code so far:</p>
  <pre><code>def highlight_cells(StartingDataFrame):
      if StartingDataFrame[StartingDataFrame['HRC'].str.contains(&quot;HRC&quot;)]:
          return ['background-color: red']*5
      else:
          return ['background-color: white']*5
  
  StartingDataFrame.style.apply(highlight_cells, axis=1)
  </code></pre>
  <p>but it doesn't seem to do anything to the cells. Is there anything i am doing wrong?</p>
  <p>Code:</p>
  <pre><code>StartingDataFrame = pd.DataFrame({'HRC':['aaa','HRD ','HRC oo'],
                                'A':[1,2,3]})
  
  
  def highlight_cells(x): 
     c1 = 'background-color: red'
     c = 'background-color: white'
  
     #if True are strings
     m1 = StartingDataFrame['HRC'].str.contains(&quot;HRC&quot;)
  
     df1 = pd.DataFrame(c, index=x.index, columns=x.columns)
     df1.loc[m1, 'HRC'] = c1
     return df1
  StartingDataFrame.style.apply(highlight_cells,axis=None)
  StartingDataFrame.to_excel(&quot;outputTest.xlsx&quot;)  
  </code></pre>