Using Conditional Formatting with Alternating Colors
Trying to get my columns (AA31:AB59) to alternate colors based on a text value in cell AT2, with each text value corresponding to a different color scheme:
If you see "Word1" in cell AT2, then use green alternating color scheme in AA31:AB59
If you see "Word2" in cell AT2, then use blue alternating color scheme in AA31:AB59
If you see "Word3" in cell AT2, then use red alternating color scheme in AA31:AB59
I have =$AT$2="Word1" to get it all one color but I'm not sure how to achieve alternating colors for the column
EDIT: PART 2
I also would like the non-zero numbers in AA31:AB59 to be bolded if/when they are input, but it seems a second conditional formatting rule cancels out the color-based formatting