Results 1 to 7 of 7

Thread: If cell is colored enter a letter to it

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jul 2008
    Posts
    50
    Location

    If cell is colored enter a letter to it

    I want to look at a column and if a cell has been highlighted by a certain color then place a letter N in that cell. Also if a different color is in the column then place a LS in that cell.
    I am not sure what I am missing. It looks Ok in the module and does not flag until I try to run it.

    If Range("F1:F101").Cell.Interior.ColorIndex = 4 Then
        Cell.Value = "H"
        If Cell.Interior.ColorIndex = 15 Then
            Cell.Value = "LS"
        End IF
    Last edited by Aussiebear; 01-13-2025 at 12:30 AM. Reason: Added code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •