Forum Discussion
Conditional formatting of a single cell by row
=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 must be missing something simple, but I am not sure how to get the Conditional Formatting Pane to allow me to change the "Applies To" section? When I double click it, it edits the original formula instead?
(I am doing this on macOS so maybe that's why?) OliverScheurich
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!