Detect cell colour

D

David

I have spreadsheets where 5 cells have general titles and have
different background colours. In other sheets, dozens of cells list
topics and are also colour coded to show which general title they refer
to.

I need to tabulate information so that a row would contain three cells:
the general title, a topic and data about it.

Is there a command that returns the colour of the cell background, so
that I could use this to select the correct title to accompany the
topic?
 
M

mmaatman

Hi,

Yes there is:


FontC = Worksheets("Planning").Cells(<Row>,
<Column>).Font.ColorIndex
InteriorC = Worksheets("Planning").Cells(<Row>,
<Column>).Interior.ColorIndex

Just give a valid value in <Row> and <Column>

Greetings from the Netherlands
Marcel

David schreef:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top