I am trying to make one column gray based on the whether or not the value in
the previous column =Y. Do I use "formula is" in Conditional Formatting, and
what then would the formula be?