VBA row highlight if specific cell not empty

**royUK** · Feb 24th 2020

Looking at your example, do you want to highlight each row if it contains no blanks, just in the Table area?

zsolti90 · Feb 24th 2020

Yes, excatly what i would like to do. This is just something extra, i dont know its possible or not, But if i remove the value the highlight as well should be remove. But if its not posible, more than enough for me, if get value in D column jsut highlight that row. Which is empty its have to stay without highlight.

**royUK** · Feb 24th 2020

That's how Conditional Formatting works. I'll look at your example

**royUK** · Feb 24th 2020

Is this whatb you want?

zsolti90 · Feb 24th 2020

Yes! Tank you very much. its work very well. Really thank you your help!

**royUK** · Feb 24th 2020

Pleased to help. It's better to be sure you have a good knowledge of all Excel's inbuilt features before resorting to VBA.

Here's a Tutorial on Conditional Formatting

VBA row highlight if specific cell not empty

Participate now!

Share

Tags

Users Viewing This Thread