Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Can macro test fill color in cell with conditional format?

Is it possible for a macro to test the fill color that is generated by
a conditional format? If so, how?

TIA


John Keith

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Can macro test fill color in cell with conditional format?

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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Can macro test fill color in cell with conditional format?

On Jan 8, 9:15*am, Gary''s Student
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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Can macro test fill color in cell with conditional format?

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
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill autoshape color with ref cell conditional formatting Julie Excel Worksheet Functions 1 May 16th 08 05:01 PM
Color Cells by macro NOT conditional format DTTODGG Excel Programming 9 July 26th 07 08:26 PM
Can search by cell format like fill color? T-Diego Excel Worksheet Functions 1 April 29th 06 12:23 AM
Cell Formatting Conditional On Other Cells Fill Color? [email protected] Excel Programming 2 April 6th 06 05:22 PM
Cell Formatting Conditional On Other Cells Fill Color? [email protected] Excel Worksheet Functions 1 April 5th 06 10:05 PM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"