Macro to highlight cell based on value in below row

[jamesbailey0]

Hi,

I am looking for a macro to highlight a cell based on the rule it has a blank cell below.

The data series looks like the below and has 15,000 rows:

Cells.png

Thanks in advance.

[Obsessed]

Try:

Please Login or Register  to view this content.

[alansidman]

try this:

Please Login or Register  to view this content.

[jamesbailey0]

Perfect! Thanks!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep