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
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks