View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Conditional Formatting in a Macro

Hello I have the following Macro:

Sub Comma()
Range("K3").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Style = "Comma"
End Sub

How can I add maybe after Selection.Style a line into this Macro with a
Conditional Formating that IF $B3 is equal to "1" then I want to have a Black
cell shading and White Arial Bold font style.

thanks!