title: Set conditional background color of cell based on text using EPPLus in C#.net
body: <p>I am using Epplus For Export to Excel.</p>
  
  <p>i want to set the background color of column 1 and 2 based on column 1 value. if any cell in column 2 cells contain 1 then the background color of col1 and col2 is of Green. if it contains 2 then the background Color must be light yellow. Like below Image.</p>
  
  <p>Now I am able to set only 2nd column background color. if i set the range then it set the background color based on the Last condition and color the entire column as yellow. Please help me out. 
  <a href="https://i.stack.imgur.com/qfUbK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qfUbK.png" alt="enter image description here"></a></p>