Help Using Formulas in Conditional Formatting

[Guest]

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?

 

[Bob Phillips]

Assuming the cell is B1,

=A1="Y"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob,

Thanks a million! I wasn't using the quotation marks. So simple!!