Help Using Formulas in Conditional Formatting
 

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?

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?

Bob,

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


"Bob Phillips" wrote:

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?