VBA Macro to Evaluate cells based on if column contains criteria

[tharrington]

In my array, I have a macro that colors cells yellow or red depending on numerical criteria.
I am now looking for a bit of code that counts the maximum number of yellow cells in a row, that do not have a red cell in that column.

So a count if type statement that counts when yellow and doesnt have red above or below it.

Thanks ahead of time

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-while-nested-if-post5107790.html#post5107790

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

This is the second time that you have duplicated this thread, despite the fact that you have a response on the original to which you haven't replied.