Conditional Formatting - Checking Cell Colours | Excel forum

Resolved · Low Priority · Version 2003

Tue 23 Feb 2010, 15:19 Delegate Alan said...

Alan has attended:
Excel VBA Intro Intermediate course

Conditional Formatting - Checking Cell Colours

Hi,

I am trying to figure out a way to check the ColorIndex of cells in Excel.
I think the problem is that the ColorIndex of the cells in question is decided by conditional formatting

Basically there are red cells (ColorIndex 3) and green cells (ColorIndex 35), the Pattern is xlsolid.

I want to create an If statement a bit like this:

If cells(Row,Column).ColorIndex = 3 Then
.......
End If

I think because the colorindex is decided by Conditional Formatting it isnt picking up.

Any ideas?

Many thanks,

Alan

Thu 25 Feb 2010, 11:02 Trainer Jacob said...

RE: Conditional Formatting - Checking Cell Colours

Hi Alan

Thanks for your post, we have had a look at this and there isn't a clear cut solution available without a couple of hours work and having your working files to hand.

As this is beyond the scope of the forum, if you wish to proceed then please respond to my email. We will be able to review your files and give you a scope of work and any related costs.

Regards

Jacob

Thu 25 Feb 2010, 11:05 Delegate Alan said...

RE: Conditional Formatting - Checking Cell Colours

Thanks for getting back to me.

Not a problem. There are other ways around the problem as I can just use the conditions that derive those colour formats to make decisions.

Thanks again,

Alan

Training courses