1. Select cell A1. Then press (Ctrl+A) to select all cells
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF(1:1,"*TOTAL*")
4. Click Format ButtonPattern 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
---------------
Jacob Skaria


"Tree" wrote:

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...