Jump to content

Excel Color Pallette Reversed (Solved)


Skeletor
 Share

Recommended Posts

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

 

Kind Regards
Skeletor

"Coffee: my defense against going postal."

Microsoft Office Splash Screen | Basic Notepad Program (Beginner) | Transparent Splash Screen | Full Screen UI

Link to comment
Share on other sites

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

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

  • Moderators

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

"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Link to comment
Share on other sites

@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

 

Kind Regards
Skeletor

"Coffee: my defense against going postal."

Microsoft Office Splash Screen | Basic Notepad Program (Beginner) | Transparent Splash Screen | Full Screen UI

Link to comment
Share on other sites

  • Skeletor changed the title to Excel Color Pallette Reversed (Solved)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...