Formatting based on one cell

[kaori]

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

 

[kaori]

<<<<< *HELP from BRAZIL* >>>>>

When using Conditional Formatting you need to point to a Cell.

*Example:*
The *3* row will be formated based on Conditional Formatting
The criteria will be the value of M10 cell.

Then select the row 3, go to conditional formating and the fórmula is
=$M$10="T". Select the desired lay-out. OK

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 unde
conditional formatting. This is for a table which is about 700 rows lon
and 30 columns wide. The M column has either T, tx, or ext and I woul
like all the rows that have "T" in the M column to be bolded with
border up top.
Thank you for your reply and help

 

[Gord Dibben]

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

 

[kaori]

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

;1601648']I would first select all the cells in the range....30 cols
700 rows.

Then enter your formula in "use a formula".

=$M2="T"

Format as you like.


Gord

On Tue, 8 May 2012 20:26:11 +0000, kaori

Mazzaropi;1601617 Wrote: -

I tried what was recommended and it is still not formatting as desire.
I also meant to write "=$M2="T". This is what I put in the formul under
conditional formatting. This is for a table which is about 700 row 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.

 

[Gord Dibben]

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