Ivan F Moala's Color Banding to identify current cell

MrExcel

.
Builders Club Member
Joined
Feb 8, 2002
Messages
3,394
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,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

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