Excel Color Pallette Reversed (Solved)

[Skeletor]

Hi All,

While creating a few excel spreadsheets using AutoIt, I came across something which to my limiting time to research the forums I don't anyone has mentioned. 

The color pallettes are reversed. 
Huge shock to me.

 

I wanted to produce a red row but kept on getting blue. 
Seems like 0xFF0000 was red on the charts but when running the script, I got blue. 

I then played around with the colors, and after a few tries, I finally got Red. 

Reversed the FF0000 and the result is 0000FF.

 

So for Excel compared to Html

0000FF (Red) - Excel
0000FF (Blue) - Html

FFFF00 (Cyan) - Excel
FFFF00(Yellow) - Html

 

[water]

The wiki explains how to calculate color values. https://www.autoitscript.com/wiki/Excel_UDF#Color.2C_ColorIndex

[JLogan3o13]

Moved to the appropriate forum, as the AutoIt Example Scripts forum very clearly states:

Quote

Share your cool AutoIt scripts, UDFs and applications with others.

---

Do not post general support questions here, instead use the AutoIt Help and Support forums.

Moderation Team

[Skeletor]

@water With ColorIndex, works that way, but using the plain ol' Interior.Color this requires reversal. 

With $oExcel.ActiveWorkbook.Sheets(1)
        .Range("A1:I1").Interior.Color = 0x00FFFF
    EndWith