Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I've set up a Condtional Format with the following code: Range(Cells(5, 8), Cells(Rows.Count, 1)).Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=$g5 $h5" Selection.FormatConditions(1).Interior.ColorIndex = 4 It works fine, however I only want column H (after row 5) to be Formatted and this will Format columns A thru H. Thanks for any help. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quick question on sheet format | Excel Discussion (Misc queries) | |||
rookie question | Charts and Charting in Excel | |||
Excel Rookie Question | Excel Programming | |||
VBA Question (rookie issue) | Excel Programming |