Count consecutive cell until blank and change the cell color.

Hi,

Need help to make a conditional formatting or a macro that count consecutive values until blank and change the cell color.
The 5th consecutive cell to yellow, 6th consecutive cell to orange and above the 7th consecutive cell red.

Sorry about my bad english! Thanks in advance.

Really need help on this, someone please...

VBA example

Please Login or Register  to view this content.

Originally Posted by jindon

VBA example

Please Login or Register  to view this content.

Man, thanks for the help, that was exactly what I needed!
Saved me so many hours of work.really thank you!

Arigatou!

You are welcome and umaku dekite yokatta.

1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

2)
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 advices Jindon san!

One question about the code,
it will work perfectly on cells that I have fill manually,
but it does not work on cells that I have a hlookup formula on it.

the formula I'm using is

Please Login or Register  to view this content.

can it be done?

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks for the quick reply,
it worked on cells that I had formula on it

anyway to combine both? counting formulas and manual fill?

Change to

Please Login or Register  to view this content.