Excel - Formatting based on one cell
Asked By kaori on 08-May-12 11:30 AM
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.
kaori replied to Mazzaropi on 08-May-12 04:26 PM
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.
Gord Dibben replied to kaori on 08-May-12 11:51 PM
I would first select all the cells in the range....30 cols x 700 rows.
Then enter your formula in "use a formula".
Format as you like.
kaori replied to Gord Dibben on 10-May-12 03:17 PM
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
'Gord Dibben[_2_ Wrote:
Gord Dibben replied to kaori on 10-May-12 08:07 PM
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