PC Review


Reply
Thread Tools Rate Thread

Can macro test fill color in cell with conditional format?

 
 
John Keith
Guest
Posts: n/a
 
      8th Jan 2009
Is it possible for a macro to test the fill color that is generated by
a conditional format? If so, how?

TIA


John Keith
(E-Mail Removed)
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      8th Jan 2009
This topic is very well covered in:

http://www.xldynamic.com/source/xld.CFConditions.html
--
Gary''s Student - gsnu2007k


"John Keith" wrote:

> Is it possible for a macro to test the fill color that is generated by
> a conditional format? If so, how?
>
> TIA
>
>
> John Keith
> (E-Mail Removed)
>

 
Reply With Quote
 
John
Guest
Posts: n/a
 
      8th Jan 2009
On Jan 8, 9:15*am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> This topic is very well covered in:
>
> http://www.xldynamic.com/source/xld.CFConditions.html
> --
> Gary''s Student - gsnu2007k
>


Thank you! That is an excellent reference. (Why didn't that show up on
my google search???)

JK
 
Reply With Quote
 
Gary''s Student
Guest
Posts: n/a
 
      8th Jan 2009
xldynamic does not cover a vast number of topics, but what it does cover, it
covers very thoroughly.

There are a number of other websites that give excellent Excel hints and
tutorials.
--
Gary''s Student - gsnu200825


"John" wrote:

> On Jan 8, 9:15 am, Gary''s Student
> <GarysStud...@discussions.microsoft.com> wrote:
> > This topic is very well covered in:
> >
> > http://www.xldynamic.com/source/xld.CFConditions.html
> > --
> > Gary''s Student - gsnu2007k
> >

>
> Thank you! That is an excellent reference. (Why didn't that show up on
> my google search???)
>
> JK
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill autoshape color with ref cell conditional formatting Julie Microsoft Excel Worksheet Functions 1 16th May 2008 05:01 PM
Can search by cell format like fill color? =?Utf-8?B?VC1EaWVnbw==?= Microsoft Excel Worksheet Functions 1 29th Apr 2006 12:23 AM
Cell Formatting Conditional On Other Cells Fill Color? Kael_Sidhe@yahoo.com Microsoft Excel Programming 2 6th Apr 2006 05:22 PM
Cell Formatting Conditional On Other Cells Fill Color? Kael_Sidhe@yahoo.com Microsoft Excel Worksheet Functions 1 5th Apr 2006 10:05 PM
Re: How do I use Cell Fill Color as a logical test? JE McGimpsey Microsoft Excel Worksheet Functions 0 10th Sep 2004 02:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:04 PM.