STREAMLINED CODE TO HIGHLIGHT OR UNHIGHLIGHT A RANGE

[Eddie G.]

I currently used some clunky code that was written some years ago and I know there is a more streamlined way to do it....... i have a worksheet where is number greater than 1 is placed in a cell in a range, lets say, b2:b25 ,which causes the activecell (b2) and seven cells to the right to unhighlight. I need simpler code that will do this, as well as highlight the seven cells to the right if the number in B2 is deleted (blank cell)

 

[wcassell]

Can you just use conditional formating to make the cells look the way you want based on the formula you choose? For example you could conditionally format cells c1:c10 to be highlighted if the formula =isblank(b2)='Y' is true.

 

[sen_edp]

HELLO

I AGREE

USE CONDITIONAL FORMATTING, IT IS NICE, AND NO VBA CODE NEEDED.

RGDS

ANDREAS

 

[Eddie G.]

thanks, you're right, all the clunky code was replaced by conditional formatting.