Jul 04 2023 08:05 AM
Hi everyone,
I have a spreadsheet which has conditional formation for dates, but I want to go one step further and base the client name or the format cell colour to match the row at the same time. Any idea's as everything I try isn't working.
Thank you in advance
Jul 10 2023 08:20 AM - edited Jul 10 2023 08:23 AM
If I understand right you basically want the color bar on the right under the dates to match the color of the client name. you will need to create a new rule for each client with the conditions for creating the bar and with $A1=client1 and set the format color for client1 (note you can include in the formula a condition to always include the client column A in that rule and hence let conditional formatting color those cells too). So something like:
Applied to A1:ZZ10000
Custom Formula: =("Client1"=$A1)*((Column(A1)=1)+( formula for date columns ))