Conditional Formatting for Simple and Merged Cells in Excel

arnao3340 Posted messages 8 Status Membre -  
arnao3340 Posted messages 8 Status Membre -
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 réponses

Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
No: we need the 5 rules.

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