Conditional formating

Closed
Mack - Sep 7, 2016 at 01:35 PM
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Sep 7, 2016 at 02:33 PM
i have a row of initials:
MM MM MM MM LL LL LL BB XX XX MM CC CC CC, each pair is a column
these correspond to booking dates, so if the initial next to it is the same make it one color,
MM MM MM MM, LL LL LL, BB, etc. > this would be three colors (the initials can be any combination.
ie: MM booked 4 days, LL 3 days, BB one day.

so at a glance I can tell by color how long is the contiguous stay.

note the MM in front of the CC's is not necessarily part of the first MM's

1 response

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
Sep 7, 2016 at 02:33 PM
Perhaps this FAQ will help:

http://ccm.net/faq/2081-unlimited-conditional-formatting