Jan 05 2022 09:43 AM
I'm looking to change the color of a cell based on the color of the cell directly to the left of it. I already have the cells to the left changing color based on a word in the cell using conditional formatting and it works fine. I have to change the cells by hand on the right. What can I do to make them change together?
Jan 05 2022 09:59 AM
If i correctly understand what you want to do it's only a simple change of the rule for conditional formatting.
In the attached file the rule
=$C2="Moon"
highlights both cells C3:D3.
Rule
=C2="Moon"
would only highlight cell C3.
Jan 05 2022 10:49 AM
I tried using your formula in a different part of the sheet, however, it didn't even change the main box. Is there something I am doing wrong? See attached photos for sample formula and the one I use for the actual coloring.
Jan 05 2022 11:24 AM
Jan 05 2022 11:38 AM
=ISNUMBER(SEARCH("unpaid",$H1))
=ISNUMBER(SEARCH("paid",$H1))
For the actual conditional formatting i tried above rules and it works in my spreadsheet as shown in the attached file.
Jan 05 2022 11:47 AM
Jan 05 2022 12:00 PM