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
Bookmarks