Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Conditional Formatting in Excel
#1
Why doesn't work?

Macro
Code:
Copy      Help
ExcelSheet es.Init
Excel.Range s=es.ws.Range("M:M")
s.FormatConditions.Delete
s.FormatConditions.Add(Excel.xlExpression @ "=ABS(L1-M1)>3")
s.FormatConditions.Item(1).Font.ColorIndex=3
s.FormatConditions.Item(1).Font.Bold=TRUE
#2
Formats numbers bold red.

I also inserted
s.Select
#3
Inserting s.Select works.

Thanks.


Forum Jump:


Users browsing this thread: 1 Guest(s)