Hi
try
with worksheets("dialog11").range("A1")
..FormatConditions.Delete
..FormatConditions.Add Type:=xlExpression,
Formula1:="=$U2<"""""
..FormatConditions(1).Interior.ColorIndex = 35
end with

--
Regards
Frank Kabel
Frankfurt, Germany


The following VBA code creates conditional formatting for the
selected
cell so that if a number is present in cell U2 the selected cell
turns
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
want
it applied to cell A1 on sheet "Dialog11"?

Any ideas?

Andi


---
Message posted from http://www.ExcelForum.com/