FORMAT ENTIRE ROW BASED ON SPECIFIC TEXT

  • Thread starter Thread starter Tree
  • Start date Start date
T

Tree

EXCEL 2007
I need to have an ENTIRE row bolded IF anywhere in the row is the word
TOTAL... I tried various CF but I cannot get it to apply to the entire sheet
and when I look in the forum for the answer, even though it's probably
glaring at me, I don't see how to do it..
This would be for anytime the subtotal function is run from the DATA tab..
we use this quite often, but it would be nice to have the total rowS show
more...
 
1. Select cell A1. Then press (Ctrl+A) to select all cells
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=COUNTIF(1:1,"*TOTAL*")
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

You can remove the * from the formula if you are looking for a whole cell
match.

If this post helps click Yes
 
This is great! Works very well... now, if I want to run this everytime I do
this - I would just record it as a macro and then run that.. yes?
Thank you very much Jacob..
 
Back
Top