Ivan F Moala's Color Banding to identify current cell

Joined
Feb 8, 2002
Messages
878
Office Version
365
Platform
Windows
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
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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:<pre>Formula1:="TRUE"</pre>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:<pre>Formula1:="VERDADERO"</pre>2. The more prefered option, change the code to this:<pre>Formula1:="1"</pre>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 !
 

Forum statistics

Threads
1,077,614
Messages
5,335,253
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top