Forum Discussion
Solved
Conditional formatting of a single cell by row
Hi all, After doing some research, I am a little stuck on how to make this happen. The closest I found was this topic, but it didn't work out. I am trying to change the color of a cell based...
=COUNTIF($C2:$AG2,"JT")+COUNTIF($C2:$AG2,"JK")This is the rule for conditional formatting. There's only a slight change to your formula. With this rule you don't need a value in AI2, AI3 and so on.
=$B$2:$B$27This is the range the format applies to in the example.
I don't work with macOS and therefore can't tell if that could cause a problem.
I assume it should work if you firstly delete all conditional formats of this sheet / range. Then you can select the applies to range (B2:B27 in the example) with the mouse as shown in the screenshot. Then you can start conditional formatting -> new rule and so on. That's the way i work with conditional formatting.
That did it! Thank you!