Read Excel Cell Background Colour 1

[Halliarse]

Can anyone please advise if it is possible to determine the background colour of a specific cell within Excel. I have managed to determine the font colour so I'm hopeful that it can be done as I need to export data from the spreadsheet and place it specifically in a column on a CSV file based on if there is a colour!

Any help or advise will be GREATLY received!

Many thanks

Steve

 

[SkipVought]

Hi,

Range.Interior.Color

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Andrzejek]

Skip knows this stuff 'by heart'.
When I want to find out the proper VBA syntax, I just create a little Macro in Excel (and 'cheat')

Macro gave me this:

    Range("F11").Select
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With

Which can be shorten to just this:

Range("F11").Interior.Color = vbYellow

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

Yea, I shuda made it more generic...

SomeRange.Interior.Color

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}