Excel Formatting by Color

Copper Contributor

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?

6 Replies

@SenorBattleship 

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.

@OliverScheurich 

 

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. Formula Used.PNGMicrosoft Help.PNG

@SenorBattleship 

In formula it shall be $F19, top left cell of the selected range

image.png

@SenorBattleship 

=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.

Can't believe I missed this. This fixed the issue, thank you.
This fixed it perfectly. Thank you for your help