Thread: Conditional Formatting using VBA Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andibevan andibevan is offline
external usenet poster
  
Posts: 1
Default Conditional Formatting using VBA Code
The following VBA code creates conditional formatting for the selecte
cell so that if a number is present in cell U2 the selected cell turn
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 wan
it applied to cell A1 on sheet "Dialog11"?

Any ideas?

And

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

Reply With QuoteReply With Quote