title: Read excel cell colour into Power BI
body: <p>I have an excel file that I need to read into Power BI. Unfortunately I have no control over this file as its auto generated from another person.</p>
  
  <p>Some of the cells in this file are just filled with colours and I want to be able to translate these colours when importing the data into Power BI.</p>
  
  <p>For example if the colour is green in excel then show true in the corresponding power BI cell. At the moment it's just blank.</p>
  
  <p>Does anyone know of a way to get cell "meta" data like colour from excel in Power BI?</p>