| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using VBA Code
The following VBA code creates conditional formatting for the selecte
cell so that if a number is present in cell U2 the selected cell turn blue:- Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression Formula1:="=$U2<""""" Selection.FormatConditions(1).Interior.ColorIndex = 35 Using the same code / formatting argument how do I specify that I wan it applied to cell A1 on sheet "Dialog11"? Any ideas? And -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting using code | Excel Discussion (Misc queries) | |||
| conditional formatting w/ more than 3 conditionas, color code to a different cell | About this forum | |||
| Override conditional formatting with code | Excel Discussion (Misc queries) | |||
| Macro code to delete conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting vba code and calculation | Excel Programming | |||
Threaded Mode
