Jump to content

temp01

Members
  • Content Count

    28
  • Joined

  • Last visited

About temp01

  • Rank
    Member

Converted

  • Campos
    ,
  • Mi versión de Excel:
    2

Recent Profile Visitors

712 profile views
  1. macro Sub colorxcondicion() Range("B10:K40").Interior.ColorIndex = xlNone For i = 10 To 40 If Cells(i, "I") = "x" Then Range(Cells(i, "B"), Cells(i, "K")).Interior.ColorIndex = 16 If Cells(i, "B") = "" Or Cells(i, "C") = "" Then Range(Cells(i, "B"), Cells(i, "K")).Interior.ColorIndex = 6 If Cells(i, "B") <> "" And Cells(i, "C") <> "" Then Range(Cells(i, "B"), Cells(i, "K")).Interior.ColorIndex = xlNone If Cells(i, "K") = 1 And Cells(i, "E") <> "" Then Range(Cells(i, "B"), Cells(i, "K")).Interior.ColorIndex = 19 If Cells(i, "K")
  2. Hola como lo adapto para mi formulario.. Feliz Año Nuevo Saludos!!
×
×
  • Create New...

Important Information

Privacy Policy