Identifying if any cell in a range meets criteria

[pholt33]

I have conditional formatting configured to identify when the current value is 0 or blank and the previous value is > 0. In the screenshot below, AN25 and AO25 are formula and result of the formatting for AM25.
Scrolling through hundreds or thousands of rows to find the highlighted cell is not sustainable.

What I would like is a formula that will identify if any cell in that row (e.g. B25:AM25) is 0 or blank and the previous date (cell to the left) has a value. How can I do that?

 

[Joe4]

Try:

=AND(OR(AM25=0,AM25=""),AL25>0)

 

[pholt33]

Try:

=AND(OR(AM25=0,AM25=""),AL25>0)

That would look at only the prior period, I am trying to get something that will find if any period (for that row) meets the criteria.

 

[Joe4]

That would look at only the prior period, I am trying to get something that will find if any period (for that row) meets the criteria.

You want each value (in all your columns) to only look at the value to the immediate left of it, right?
If you select the ENTIRE range you want to apply the Conditional Formatting to, and then write the the formula as it applies to the very FIRST cell in your selection, Excel will automatically adjust the formula for all the other cells (just like when you copy a formula down a column or across rows).

So if your numbers were in the range B4:AM100, you would first select cells C4:AM100 and enter in this Conditional Formatting formula:

=AND(OR(C4=0,C4=""),B4>0)

 

[pholt33]

The conditional formatting works fine, that's not where I am having an issue.
I know the methodology will be different because you can't look up colors/formatting in a formula, but essentially I want to know whether any period is highlighted (i.e. meets the criteria).

This doesn't work but it is along the lines of what I want. =AND( OR( ISBLANK(B4:E4), B4:E4 = 0), B4:E4 > 0 )

A simplified example below. TRUE/FALSE in F:F are manual; that is the value I want to replicate with a formula.

 

[Joe4]

Maybe your examples above do not cover all the scenarios, but it seems to me like we could just count the number of entries greater than 0, and if it is less than the number of cells, it should return TRUE.
Or is this a scenario in which that might not work (please show what that example might look like)?

 

[pholt33]

This should work or at least get me a lot closer.

Thanks for your help!