If cell color...

[jarhead58]

Hello all!

I thought this was going to be simple, and maybe it really is, but I can't seem to find the answer! I'm just looking for something to increment my count! Something like, " If R12(Interior.Color=12611584) Then count=count+1
Help is definitely appreciated!!

 

[Rick Rothstein]

No disrespect intended, sorry!!

None taken... all I was doing was explaining to you why the DisplayFormat property call was missing. Without a lengthier explanation of what your code was trying to do, there was no way of knowing that that particular code line needed the DisplayFormat reference given that you omitted it in the code you posted.

 

[jarhead58]

None taken... all I was doing was explaining to you why the DisplayFormat property call was missing. Without a lengthier explanation of what your code was trying to do, there was no way of knowing that that particular code line needed the DisplayFormat reference given that you omitted it in the code you posted.

Just for my own future reference, when would DisplayFormat not be used??

 

[Rick Rothstein]

Just for my own future reference, when would DisplayFormat not be used??

When you only wanted to check cell colors that were manually set (that is, not set by Conditional Formatting). DisplayFormat returns the color no matter how it was set (manual or Conditional Formatted).

 

[jarhead58]

When you only wanted to check cell colors that were manually set (that is, not set by Conditional Formatting). DisplayFormat returns the color no matter how it was set (manual or Conditional Formatted).

Thanks for the info Rick!