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