conditional formatting
When I click on the sheet, then click on the cell, then
check the conditional formatting, it isn't there.
-----Original Message-----
Hi
what do you mean with 'does not save'?
--
Regards
Frank Kabel
Frankfurt, Germany
scrabtree23 wrote:
It isn't that my formula doesn't work, it is that the
conditional formatting just doesn't save???
-----Original Message-----
Hi
the following works for me:
Sub foo()
With Sheets("T.S.").Range("AD10")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:= _
"=(AD10<895)*(AD10<0)"
.FormatConditions(1).Font.ColorIndex =
xlAutomatic
.FormatConditions(1).Interior.ColorIndex = 3
End With
End Sub
--
Regards
Frank Kabel
Frankfurt, Germany
scrabtree wrote:
I have wrote a VBA code to add conditional formatting
to a
cell. Here is the code:
With Sheets("T.S.").Range("AD10")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression,
Formula1:= _
"=IF(AD10=895,0,IF(AD10=0,0,1))"
.FormatConditions(1).Font.ColorIndex =
xlAutomatic
.FormatConditions(1).Interior.ColorIndex = 3
However...it isn't adding the formatting???
.
.
|