Results 1 to 19 of 19

Thread: conditional formatting to be macro on specific rows and colums

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #16
    VBAX Tutor
    Joined
    Sep 2012
    Location
    London
    Posts
    286
    Location
    Many thanks P45cal.
    I am thinking of replacing these 2 lines. Over time, I may forget that I need to format a cell in the range and still wonder why the value is changing.
    You're awesome, I'm just at a loss for words.....
    P.S - However, when I delete the first 2 lines and replace them with the second suggestion, it gives me an error and refuses to run the macro.
    Apparently I'm doing something wrong or I didn't understand it...

    v.Offset(1).Copy 'deleted this
    cll.PasteSpecial Paste:=xlPasteFormats 'deleted this
    cll.Interior.Color = v.Offset(1).Interior.Color 'I put this one
    cll.Font.Bold = v.Offset(1).Font.Bold 'and this one
    Last edited by k0st4din; 05-21-2024 at 09:51 PM.

Tags for this Thread

Posting Permissions

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