Ivan F Moala's Color Banding to identify current cell

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Ivan F Moala's Color Banding to identify current cell

  1. #1
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    857
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Ivan F Moala's Color Banding to identify current cell

     
    Kudos to Ivan. His solution to help identify the current row and column was nominated and selected as this week's Hall of Fame winner.

    The original thread is here

    A write up of the technique is here

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Ammendment:

    If you're using an Excel version that is NOT an english one, you should modify Ivan's code a bit.

    In the code you'll see this bit of code twice:
    Formula1:="TRUE"
    Change the TRUE with one of the following options:

    1. The literal transaltion to your own language, i.e., in the Spanish version, TRUE is VERDADERO, so the code would be like this:
    Formula1:="VERDADERO"
    2. The more prefered option, change the code to this:
    Formula1:="1"
    This will work with any Excel version, english and non-english, because Excel will consider the 1 as TRUE, so we have the same effect.

    That is it !
    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com