Conditional formatting if cells in row are less than header

Question

I am trying to find a way to have a cell in column A turn yellow if any cell in the adjacent row is less than the value of its corresponding header. Please see my example sheet.

I'm trying to use this formula for my conditional formatting: =COUNTIF(B5:5,"<"&B$4)>=1 but I believe it's stuck on using Cell B4 as the header value for the entire range (instead of C4 for column C, D4 for column D, etc).

Any ideas on what I'm missing here?

Answer 1

For the red option, as you suggested, you should use:

=COUNTIF($B5:$H5,"")

But you may keep it that option above, so it is red even if there's an orange

Then, for yellow you can use:

=COUNTIF(BYCOL($B5:$H5,LAMBDA(each,each<OFFSET(each,4-ROW(each),0))),TRUE)

It checks in each column if the value is smaller than in row 4, and counts the amount of TRUE values

And green should be by default, I understand. Is it useful?