Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Considering cells colored via conditional formatting
EXCEL 2007
Any piece of code which, for example, select or count the cells which are colored yellow, amongst the currently selected range, because of meeting ANY criteria of CONDITIONAL FORMATTING. In other words, considering cells which are not actually possessing yellow as an interior color but being displayed so because of CONDITIONAL FORMATTING. -- Thanx in advance, Best Regards, Faraz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Considering cells colored via conditional formatting
There are two pages at Chip Pearson's wepage that you need to look at.
the 2nd gives a detailed example of how to do what you want. 'Conditional Formatting' (http://www.cpearson.com/Excel/cformatting.htm) 'Conditional Formatting Colors' (http://www.cpearson.com/Excel/CFColors.htm) -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=174510 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Considering cells colored via conditional formatting
Consider Chip Pearson's offering on this subject:
http://www.cpearson.com/excel/colors.aspx Mike F "Faraz A. Qureshi" wrote in message ... EXCEL 2007 Any piece of code which, for example, select or count the cells which are colored yellow, amongst the currently selected range, because of meeting ANY criteria of CONDITIONAL FORMATTING. In other words, considering cells which are not actually possessing yellow as an interior color but being displayed so because of CONDITIONAL FORMATTING. -- Thanx in advance, Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - colored arrow showing positive trend | Excel Discussion (Misc queries) | |||
A macro that counts cells when the conditional formatting formula =True. i.e. the cell is colored other than white. | Excel Programming | |||
Conditional formatting: colored bar with pointer on current status | Excel Discussion (Misc queries) | |||
Count the number of times a cell is colored with conditional formatting | Excel Programming | |||
Count the number of times a cell is colored with conditional formatting | Excel Programming |