Excel VBA to identify alphabets in excel and highlight cells above it

Hi,
I have an excel with numeric data in it.

some cells have alphabets mentioned below them (from A to Z), there can be multiple alphabets in single cell, i want to highlight the cell above that.

For example if there is R in cell no. S7, i would like to highlight, S6.

my data tables starts from B7 and its ranges keep on changing (both column and rows).

I want a macros that can scan the entire excel and highlight the cell with yellow color.

Thanks in advance!!

Vicky

Maybe:

Please Login or Register  to view this content.

Hi John,
Thanks for the reply.

This VBA is working perfectly.
However, i have blanks in my data which is represented by - , this code is also highlighting cells above them, is there any possibility , it does not consider - for highlighting. ( i cannot remove - from data, i require them)

Also, i also wanted to check the possibility of 1 more macros-



In the attached excel, in tab 1,
my data is cut by country, gender, age and income (row 4)
I have cell reference in row 6.

if you look at cell N 27 . it is JKL.

Current macro will highlight N26, is it also possible to highlight K26 L26 and M26 (as per reference in column 6)

Also, it would be great, if we could use different colours for different groups - country, gender, age , income

I do not mind, selecting a set of columns and running different macros to give different colours

Thanks so much for the help

vicky

You're welcome. Try this, or if you'd prefer different colors then let me know.

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.