Hi,
I am aiming to highlight table row A17 to Q17 based on F17="Finished" and (L17="Finished" or L17 is empty "").
Any help appreciated
Hi,
I am aiming to highlight table row A17 to Q17 based on F17="Finished" and (L17="Finished" or L17 is empty "").
Any help appreciated
Select the cells A17 to Q17b and launch the CF dialog to create a new rule. Use this formula:
=AND($F17="Finished",OR($L17="Finished",$L17=""))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks, that works great. thanks. How can I amend to highlight based on F17="Started" and L17= is empty "" or F17="Finished" and L17= "Started" ?
Thus:
=OR(AND($F17="Finished",$L17=""),AND($F17="Finished",$L17="Started"))
Thank you very much
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
can this be simplified as the first 2 ranges are the same
=SUMIFS(G18:G134,P18:P134,A3,F18:F134,"Started")+SUMIFS(G18:G134,P18:P134,A3,F18:F134,"Expected")+SUMIFS(G18:G134,P18:P134,A3,L18:L134,"Started")
I suppose it depends if you think your formula is simpler!!! I'm not really sure it is. I think it would require more processing as it uses arrays.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks