View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 41
Default quick Conditional Format question <--rookie here

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