Change Color of Excel Cells

Changes the text or fill color of cells in an open Microsoft Excel Document.

Parameters

• Document name Specifies the document for reading.

• Worksheet name Specifies the worksheet which contains the cell to be read.

• Start position/row/column Specifies the start position.

• End position/row/column Specifies the end position.

• Text colorSpecifies the text color.

• Fill colorSpecifies the background color.

Notes

• The document must be opened by the instruction "Open Document" or "Create a Microsoft Excel Document" , or be connected by the instruction "Connect an Open Document" before this step.
• Microsoft Excel program must be present in the computer before playing a macro which contains this action.

• Introduction
• Editions Comparison
• Minimum Requirements
• Uninstalling
• Using Macro Expert
  • Getting Started
    • Basic Concept
    • Creating a New Macro
    • Playing a Macro Manually
    • Recording & Editing Temporary Macro
    • Playing Temporary Macro
    • Stopping Macro Service
    • Scheduling a Macro
    • Triggering a Macro
    • Disabling All Triggers of Macro
  • Macro Manager
    • Macro Manager
    • Working with Progress Window
    • Macro Player Manager
  • Options
    • General
    • Recording
    • Temporary Macro
    • Default Playback Options
    • Hotkeys
    • Macro List
    • Auto-logon
    • Mail Server
    • Proxy Server
    • Appearance
  • Script Editor
    • Looking at Script Editor
    • Editing a macro
    • Working with the variables
    • Attachments
    • Debugging a macro
    • Options
      • General
      • Hotkeys
      • View
      • Debugging
      • Internal Browser
• Macro Properties
  • General
  • Parameters for Playback
  • Triggers
    • Triggers
    • Overview of Trigger
    • Idle Trigger
    • Startup Trigger
    • System Trigger
    • Resource Trigger
    • Driver Trigger
    • Dial Trigger
    • File Trigger
    • Window Trigger
    • Hotkey
  • Schedulers
    • Schedulers
    • Overview of Scheduler
    • Scheduling a Macro
  • Advanced Options
• Internal (built-in) Functions
  • Internal (built-in) functions
  • General & Logical Functions
  • String Functions
  • Mathematical Functions
  • Date and Time Functions
  • Window Functions
  • File Functions
• Macro Commands
  • General Settings and Error Handling Options
  • Keyboard and Mouse
    • Key Action
    • Mouse Action
    • Put a Text
    • Mouse Move Activity
    • Mouse Action on Object
    • Series Keystrokes
    • Change Options of Mouse Actions
    • Change Options of Mouse Actions
  • Dialog
    • Display Message Dialog
    • Select a Folder
    • File-selection Dialog
    • Input Dialog
    • Advanced Input Dialog
    • Show Tip Text
    • Hide Tip text
    • Choice Dialog
  • Window
    • Window Action
    • Keep Window's State
    • Show or Hide Windows on Desktop
  • Wait
    • Delay
    • Wait for Mouse Pointer
    • Wait for Window
    • Wait for Color
    • Wait for UI Object
    • Wait for Keystroke
    • Wait for Mouse Action
    • Wait for Image
    • Wait for File
    • Wait for Process
    • Wait for Expression
  • Play Control
    • On Error
    • Pause
    • Stop
    • End
    • Play Speed
    • Play a Macro
    • Set Emulation Level
    • Block/unblock Mouse and Keyboard
    • Log a Playback Message
    • Redirect Play Log
    • Save Cursor Position for Restoring
    • Reset Keyboard
    • Control Running Macros
    • Set Monitor Window
    • Change Text On Monitor Window
    • Redirect Keyboard/Mouse Actions
  • Custom Functions
    • Add a Function
    • Call Function
    • Exit Function
    • Import Functions Library
  • Variable
    • Set Variable Value
    • Increase/Decrease Value
    • Advanced Set Variable Value
    • Advanced Get Variable Value
    • Swap Two Variables
    • Redefine Variable
    • Fill Array
    • Add an Element to Array
    • Delete an Element From Array
    • Sort all Elements in Array
    • Clone an Array
    • Search for Element in Array
  • Text
    • Find Text
    • Replace Text
    • Convert Text
    • Split Text
    • Pad Text
    • Get Sub Text
    • Extract Text
    • Trim Text
    • Get Text Length
    • Append Text
    • Fomat Datetime
    • Generate Random Text
  • Flow
    • Comments
    • Separator line
    • Label
    • Goto
    • If Expression
    • If Variable
    • If Color
    • If File Exists
    • If Window Exists
    • If Image
    • If UI Object
    • If Webpage Element
    • Select Case
  • Loop
    • Loop
    • Loop Array
    • Loop Windows
    • Loop Files
    • Loop Processes
    • Loop Text
    • Loop Microsoft Excel
    • Loop Dataset
    • Loop Elements of Webpage
    • Exit/Continue Loop
  • System
    • Run
    • Print a Document
    • Image Search
    • Text Search Based on Image
    • Capture Screenshot
    • Read/Write INI File
    • Read Property of Object
    • Read Object's Property From Point
    • Generate Random Number
    • Carry out Action on Object
    • End Process
    • Get Pixel
    • Get Caret (Text Cursor) Position
    • Set System Date and Time
    • Registry Operation
    • Call an External DLL
    • Send Message to Window
  • Session
    • Log off
    • Start Screen-Saver
    • Lock Workstation
    • Shut-down Computer
    • Turn Off/On Display
  • Clipboard
    • Copy, Cut, Paste and Clear
    • Put Data to Clipboard
    • Get Data From Clipboard
  • Multimedia
    • Play an Audio
    • Increase/Decrease Volume
    • Adjust Volume
    • Sound Switch
    • Sound On/Off
    • CD Player
  • Webpage
    • Open a Web page
    • Connect a Opened Webpage
    • Read Field
    • Fill Field
    • Save Image Element
    • Click Element
    • On Popup Window on Webpage
    • Submit Form
    • Find Element
    • Wait for Element
    • Close Webpage
    • Save Webpage Content
    • Save Webpage Cookies
    • Internet Explorer Navigation Actions
    • Change Window of Webpage
  • Network
    • Make Remote Access Connection
    • Disconnect Remote Access Connection
    • Connect Network Resource
    • Disonnect Network Resource
  • Internet
    • Send Email
    • HTTP Download
    • HTTP Post
    • HTTP Get
    • Ping
    • Retrieve Internet Time
    • Delete Tempoary Internet Files
    • Delete Internet Explorer Cookies
    • Clear Internet Explorer History
  • FTP
    • Log On
    • Connect Session in Parent
    • Log Off/Disconnect
    • Download
    • Upload
    • Create Folder
    • Delete Folder
    • Get Current Path
    • Change Current Path
    • Delete Files
    • List Files
    • Rename
    • Move Files
    • Move Folder
    • FTP Command
  • File
    • Copy Files
    • Move Files
    • Delete Files
    • Create a Folder
    • Delete a Folder
    • Rename Files
    • Set File Attributes
    • Change File Time
    • Synchronize Folders
    • Compress Files
    • Extract a Zipped File
    • Read Text File
    • Write Text File
    • Load Binary File
    • Find/Replace in File
    • Get File Attributes
  • Microsoft Excel Document
    • Open Document
    • Create a Microsoft Excel Document
    • Connect Open Document
    • Close Document
    • Save Document
    • Run Macro in Document
    • Read a Cell
    • Read Multiple Cells
    • Write Cell
    • Insert Excel Cells
    • Delete Excel Cells
    • Find Cell
    • Change Color of Cell
    • Add Worksheet
    • Delete Worksheet
    • Activate Worksheet
    • Wait for Cell
  • Database
    • Connect to Data Source
    • Close Data Source Connection
    • Execute SQL Statement
    • Connect Dataset in Parent
    • Close Dataset
    • Set Field Value
    • Get Field Value
    • Get Multi-fields' Value
    • Change Current Record Position
    • Transaction on Data Source
• Variables and Expressions
  • Overview
  • Variables and Arrays
  • Data Types
  • Expressions
  • Operators
• Command Line Usage
• Frequent Question and Answer
• Purchasing Macro Expert