Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Conditional Row formatting (Excel 2000 SR-1)

    <img src=/S/help.gif border=0 alt=help width=23 height=15> I have a named range and within that named range, one of the columns contains a value that is "TRUE" or "FALSE". When the column cell contains the TRUE value, I want to be able to shade the corresponding row with a light grey or something (does not matter). Since conditional formatting, as far as I could take it, only applies to cells, I suspect this requires a very simple macro to do this. Any insight that anyone can provide is greatly appreciated. (Point me to something that has already been posted??) <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/compute.gif border=0 alt=compute width=40 height=20> <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Conditional Row formatting - how to

    I found a way to do it. This uses array formulas in Excel. <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    http://j-walk.com/ss/excel/usertips/tip006.htm

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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