| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting conditional format conditions for cell
Barb Reinhardt wrote:
I have a range r (which is only one cell) and I'd like to programmatically determine if there is a conditional format condition with a formula. To add a conditional format, I do this: R.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2=1" What I want to know is if there is a formula? Thanks Something like:- Range("A1:A1000").Select Cells.SpecialCells(xlCellTypeAllFormatConditions). Select -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200611/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format with 3 conditions | Excel Worksheet Functions | |||
| 2 CONDITIONS FOR CONDITIONAL FORMAT? | Excel Programming | |||
| Conditional Formatting 4+ conditions, format rows based on cell | Excel Programming | |||
| Conditional Format - 3 conditions | Excel Worksheet Functions | |||
| more conditional format conditions | Excel Worksheet Functions | |||
Hybrid Mode
