title: How can I logically test the format of another cell in excel
body: <p>I know about conditional formatting.  I want to do the test in the opposite direction.  </p>
  
  <p>To simplify, I want to essentially do this:</p>
  
  <pre><code>if ((Text_Align(A1)='left',"L","R")  
  </code></pre>
  
  <p>or</p>
  
  <pre><code>if ((Background_Color(A1)="Pink", "Red dominates the background", "Just another blah background")
  
  if ((Fontweight(A1)="Bold", "That was a strong statement", "A cell filled by a bean counter")
  </code></pre>
  
  <p>So far I've not found a function that can do the equivalent of Text_Align -- that is, test what the value of a cell's format.</p>
  
  <p>Is this possible?</p>