Excel - Formatting based on one cell

Hello! I am trying to format an entire row based on the text value of a
single cell (bold and top border). I tried conditional formatting with
the formula =$M="T" but it does not seem to be working. What am I
missing? Thanks for your help.
K




--
kaori

Mazzaropi;1601617 Wrote:

I tried what was recommended and it is still not formatting as I desire.
I also meant to write "=$M2="T". This is what I put in the formula under
conditional formatting. This is for a table which is about 700 rows long
and 30 columns wide. The M column has either T, tx, or ext and I would
like all the rows that have "T" in the M column to be bolded with a
border up top.
Thank you for your reply and help.




--
kaori

I would first select all the cells in the range....30 cols x 700 rows.

Then enter your formula in "use a formula".

=$M2="T"

Format as you like.


Gord

Thank you! The formula worked! I also realized that it might not have
been working because I was trying to do 2 formatting tasks at once. It
worked better when I did the bold in one formula and the border line in
another.


'Gord Dibben[_2_ Wrote:




--
kaori

Having bold and colored for the same condition does not mean you have
to have seperate formulas.

You may have had both row and column Absolute........$M$2........when
you just need the column Absolute...........$M2  so all rows will look
at column M


Gord