Hi newbie Excel macros and VBA user here...
I need either macro or VBA code to do the following:
find keyword (not case sensitive) in column E which contains various text notes.
if found, change font color in matching B column cell
Then repeat for all cells in column to final row.
Note I have 3 sections of rows in the spread that are separated by blank rows for subtotalling.
Note2: I actually have two keywords ("died" and "d/c") that I need to find then colorcode the B col cell font
different colors. Bold Blue for died. And bold green for d/c.
I think I should be able to do with a loop or If, Elseif type vba code...but can't figure how to write it.
Would so appreciate any help.
Thanks!
I need either macro or VBA code to do the following:
find keyword (not case sensitive) in column E which contains various text notes.
if found, change font color in matching B column cell
Then repeat for all cells in column to final row.
Note I have 3 sections of rows in the spread that are separated by blank rows for subtotalling.
Note2: I actually have two keywords ("died" and "d/c") that I need to find then colorcode the B col cell font
different colors. Bold Blue for died. And bold green for d/c.
I think I should be able to do with a loop or If, Elseif type vba code...but can't figure how to write it.
Would so appreciate any help.
Thanks!