title: Pandas Conditional Formatting BITAND
body: <p>i have the script to check aws tags.
  For all resource the required tags was checked.
  Now i try to color bad tag value.
  I use column State to determinate column to color with BITAND operation.</p>
  <pre><code>        i = 0
          for i in range(len(self.config[&quot;tags&quot;])):
              worksheet.conditional_format(0,  start_tag_column+i, max_row,  start_tag_column+i,
              { 'type':'formula','criteria': f&quot;=BITAND($I1,{2**i})={2**i}&quot;,  'format': format_bad})
  </code></pre>
  <p>When I open xls the condition format was presented but it doesn't work</p>
  <p>see <a href="https://docs.google.com/spreadsheets/d/1c-EsViLr3mXtnK6E14VM8cWfzk2wqq_N/edit?usp=sharing&amp;ouid=106966081364843441987&amp;rtpof=true&amp;sd=true" rel="nofollow noreferrer">ko.xlsx</a></p>
  <p>When I edit (open/save) conditional format rule - all works fine,</p>
  <p>see <a href="https://docs.google.com/spreadsheets/d/1xEnYMv-99aDk2ymVDv4OmKoZ2NKf-41j/edit?usp=sharing&amp;ouid=106966081364843441987&amp;rtpof=true&amp;sd=true" rel="nofollow noreferrer">ok.xlsx</a></p>
  <p>Any ideas?</p>
  <p>Thank you!</p>
  <p>p.s. i use macos m2, Python 3.10.6, pandas==1.4.4, XlsxWriter==3.0.3, Microsoft Excel For Mac 16.65</p>