Conditional Formatting for Simple and Merged Cells in Excel

arnao3340 Posted messages 8 Status Member -  
arnao3340 Posted messages 8 Status Member -
Hello,

I'm reaching out because I'm having trouble entering a formula that would allow a group of cells to take on a different formatting based on the value of one of those cells.
I'm attaching an image to help illustrate my issue.


I would like to know if it's possible for the client, address, truck, time, and type of delivery (e.g., Pickup in C4) to be the same based on the type of delivery all in one rule? (So here, text in green for Pickup, for example)

Thank you in advance :)

3 answers

  1. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    No: we need the 5 rules.

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0