Ivan F Moala's Color Banding to identify current cell

Joined
Feb 8, 2002
Messages
3,381
Office Version
  1. 365
Platform
  1. 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
 
Last edited by a moderator:
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,212,927
Messages
6,110,714
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top