title: Can VBA Arrays store cell properties like Font Colors or Fill Colors?
body: <p>The screenshot below shows that dates filled are highlighted with different colors and I need to add more to flag different issues from the installation process. </p>
  
  <p><a href="https://photos.app.goo.gl/P8Yb1bPZHP5j6Dkb9" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BA68q.png" alt="img"></a></p>
  
  <p>I have to calculate productivity and account for the installation issues in the calculation. The only way for me to identify the issues is by assigning different fill colors/font colors.</p>
  
  <p>If I pass this range of data in a variant array, <strong>will I be able to refer font/fill color properties</strong> or is there an indirect way to refer to the cell address from the array?</p>