Assuming the cell is B1,

=A1="Y"

--

HTH

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


"Still Learning" <Still wrote in message
...
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?