VBS Scripting Help

Question

VBS Scripting Help

Dano-94-79 1

Hello friends,
Was hoping to get some help on creating a vb script to highlight some data.

In a spreadsheet, in column F, I have a certain value highlighted. I need to be able to find that highlighted value (EBB Access) and have the cell immediately below it highlight (or change font or something to easily identify it).

Any help would be very much appreciated.

2 answers

Your answer

Answer 1

Michael Taylor 60,161

Rather than using a script why don't you use conditional formatting instead. Given the column you could apply the conditional format expression =INDIRECT(ADDRESS(ROW()-1,COLUMN()))="EBB Access" to the column. Any row that is immediately preceded by a row with that value in the same column would then be formatted how you want.

Answer 2

Dano-94-79 1

Thanks for the info but, I'm an idiot and am having trouble getting it to work.
In the conditional formatting formula I am entering =INDIRECT(ADDRESS(ROW(3)-1,COLUMN(7)))="EBB Access" to no avail. Tried may other combos too.
If the starting row is at row 3 for all of column G, what should that look like? Can't thank you enough.

Michael Taylor 60,161 Reputation points

2022-04-28T18:23:54.983+00:00
Don't put any #s in the ROW or COLUMN functions.

Select the column header in Excel to select the entire column.

Under the Home ribbon bar select Conditional Formatting.

Click the Manage Rules and add a new rule for this formula.

Put the formula in exactly as I provided.

Set the Format to whatever formatting you want.

Set the Applies to to the range of the columns (e.g. $F).

Click Apply.

The formula will take each row, look at the value in the previous row's column (ADDRESS(ROW()-1, COLUMN()) and if it matches the value given then set's the current row's column formatting accordingly.

Share via

VBS Scripting Help

2 answers

Your answer