Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ted Collins   on Dec 01 In MS Office Category.

  
Question Answered By: Anuja Shah   on Dec 01

If you want to find  a cell  by colour, you can certainly do so. From memory, you
need the Interior property of the cell, and probably the PatternColor property
of that ...

Range("a1").Interior.PatternColor

However, you're better using other information to tell you where the green cell
should be, and then make it green.

Normally, I'd use conditional formatting for conditional colouring like this.

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to step into a formula with a macro? Or get search suggestion and latest updates.


Tagged: