How to set Color RGB of specific letter by value calc?

[countervector]

Hi, How I do that?
For Example, I have value called "4" in the `A1` Cell I need to set color Blue or like this:

Code: Select all

oCell.LetterColor.RGB(0,0,100)

[Zizi64]

Use the Styles instead of the direct (manual) formatting method.

[Villeroy]

Conditional formatting is the feature which formats cells based on conditions based on formula expressions. There is also a STYLE function.

[countervector]

Please give me a small fragment of code (macro), need certainly RGB methode, but not a style methode, please help me.

[Villeroy]

[Tutorial] Introduction into object inspection with MRI

[Zizi64]

First download, install, study and use one of the excellent Object inspection tools: the MRI or the XrayTool.

Then you will able to examine the programming objects by listing theit properties, methods and interfaces.

Code: Select all

oCell = ... (get the cell what you want to examine)
REM: examine the object oCell:
xray oCell