Conditional formatting, based on non-blank cell from list of cells

Hi guys,

On my sheet, on ym first tab,

I want a formula to look like this as part of a conditional formatting:

=LOOKUP(2,1/(C2,E2<>""),C2,E2)=1

Basically on my first tab, I want A4 to be formatted, based on the last non-blank cell value from C2 AND E2.... (I will add more for now I juat need to know if this is possible please)

Thank you in advance

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...lank-cell.html