| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
the value of a condition in a conditional format
Bob!
thanks. I found that I could just run through the cells selecting them .... Cells(i, j).Select ' because I use European separators... formatCond = Application.Substitute(Selection.FormatConditions( 1).Formula1, ";", ",") If Selection.Parent.Evaluate(formatCond) Then .... to get the right relative positioning for the evaluation of formula1. Eric On 9 Jan, 16:17, "Bob Phillips" wrote: Not simple, but seehttp://www.xldynamic.com/source/xld.CFConditions.html -- --- HTH Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting - copy format & remove condition | Excel Discussion (Misc queries) | |||
| Retain Conditional Format When Condition Is No Longer Valid | Excel Discussion (Misc queries) | |||
| Conditional Format to highlight entire row if a condition is met | Excel Worksheet Functions | |||
| use more than 3 condition in conditional format | Excel Worksheet Functions | |||
| Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
Threaded Mode
