2 Replies Latest reply: May 15, 2014 10:05 AM by Olly Bond RSS

    XLSX Cell Colors

    elginreigner _

      Can the v10 Monarch Pro read cell colors in Excel XSLX files?

        • XLSX Cell Colors
          Data Kruncher

          While you can now with v10 set any RGB value (or even HSL value) for many items within Monarch, Monarch will not currently detect the colors used in an Excel xlsx file.

            • XLSX Cell Colors
              Olly Bond

              Hello elginreigner,

               

              Assuming you want to be able to say, interpret a red cell background as a negative number, and others as positive, then I think you'd be better off scripting this in Excel before passing the data to Monarch. I don't think you can do this just using the formatting options in Excel's find & replace dialog.

               

              Best wishes,

               

              Olly