Macro for alternate color based on cell value

You do not need a macro for this.

Use one or two conditional formats.

Select B8 to L28

Click on Home and then conditional format

Select new rule and then use a formula.

Paste this into your formula box and then select format and fill and select a colour.

Formula:

Please Login or Register  to view this content.

If you feel you need a second colour then:


Select B8 to L28

Click on Home and then conditional format

Select new rule and then use a formula.

Paste this into your formula box and then select format and fill and select another colour.

Formula:

Please Login or Register  to view this content.

Thank you so much dear Expert. Perfect Solution. Really appreciated your expertise.

Many Regards,

Neilesh

Neilesh - please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

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

Now you have a problem.

Conditional formatting cannot recognise when a row is hidden.

So use a hidden column to store a series of numbers that Conditional formatting will recognise.

*********************************************************************************

I have inserted a new column A. This column can be hidden or the text colour can be set to white.

*********************************************************************************


I have modified the conditional format formula

Formula:

Please Login or Register  to view this content.

Set it to apply to range $C$8:$M$200

I have modified your macro:

Please Login or Register  to view this content.