Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Conditional Formatting - Checking Cell Colours
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Conditional Formatting - Checking Cell Colours
Resolved · Low Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Conditional Formatting - Checking Cell Colours
Hi AlanThanks 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
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
|
 |
|
» Forum post: Templates |
Where can I find the templates to amend them?
