highlight if 3 consecutive cells are 0

[chas3]

If D4=0, E4=0, and F4=0, i would like to highlight D4, E4, F4. How do I make that happen?

 

[MrTeeny]

Have you looked at conditional formatting rather than VBA, a conditional formula of =AND(D4=0,E4=0,F4=0) should be sufficient

 

[MrKowz]

If D4=0, E4=0, and F4=0, i would like to highlight D4, E4, F4. How do I make that happen?

Welcome to the forums!

You should be able to achieve this through conditional formatting. Are you wanting to apply this to a larger range (i.e. D:F entire columns?) or are you only needing to highlight these three specific cells?

 

[chas3]

Yes, My data range is D4:AH49. It's a sales tracking sheet. I want to highlight when there have been no sales for 3 consecutive days for each salesperson. Sales people are in Column B from B4:B49, days of the month are across the top from B4:AH49. Using the AND statement referenced above fails to highlight the last two days of the 3 (or more) day string

 

[chas3]

I tried the AND statement but it doesn't highlight the last two days of the 3 or more day string of 0s. Any ideas on how to get it to highlight every cell with a 0 when there are 3 or more consecutive cells in a row with 0?

 

[Rick Rothstein]

I tried the AND statement but it doesn't highlight the last two days of the 3 or more day string of 0s. Any ideas on how to get it to highlight every cell with a 0 when there are 3 or more consecutive cells in a row with 0?

Are your numbers in the range D4:AH49 constants or the result of formulas?

Also, is the range D4:AH49 fixed and never changing?

 

[chas3]

The numbers are the result of formulas pulling from another worksheet in the same workbook. The range is fixed and should not change.