title: How to change/Set Background color of a cell [Row-based] in Power BI
body: <p>I have a table report in Power BI. I need to change/Set background color of a Cell based on another cell value as follows.</p>
  
  <p><a href="https://i.stack.imgur.com/V1TmN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V1TmN.png" alt="enter image description here"></a></p>
  
  <p>Eg: Row1 - Individual Cell's background color changes to green if corresponding Expected val is reached[85>70].</p>
  
  <p>I found <a href="https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting" rel="nofollow noreferrer">Conditional formatting in tables</a> has this ability. I'm not able to get value of cell and make comparison to achieve color coding. </p>
  
  <p>Please suggest on how to extract value of cell in Power BI to set/change background color.</p>