Ken Puls
08-26-2005, 01:46 PM
Hey guys,
Having a bit of an issue trying to set a conditional format via code for a group of cells. What I'm trying to do is have the entire row highlight grey if column C contains an #N/A error.
I've got this so far:
.Cells.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ISNA($C1)"
There doesn't seem to be an R1C1 method for this that I've found yet though...
Any ideas?
Having a bit of an issue trying to set a conditional format via code for a group of cells. What I'm trying to do is have the entire row highlight grey if column C contains an #N/A error.
I've got this so far:
.Cells.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ISNA($C1)"
There doesn't seem to be an R1C1 method for this that I've found yet though...
Any ideas?