Did you enter A1 or $A1?

If you data is in A1:Z100 then select the whole range and then enter the
formula...

It will highlight row n based on the cell An...


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Dinesh" wrote:

Based on the formula, it only highlightds the one cell (A1) but not the
entire row or does not allow to put the other parameter. (for example: to
highlight a thru g)

Dinesh

"Sheeloo" wrote:

Select the cells including row 1
In conditional formatting use formula is =$A1="Total" and format as desired...

Formatting does not translate to formulas/PIVOT tables...

I have not tried to do conditonal formatting in PIVOT table... I will get
back to you on that tomorrow... if someone else does not provide the answer...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Dinesh" wrote:

I want to right a macro or if i can use condition format where I want to
highlight the rows if col A contain text as "Total".

How would it work also if I run the Pivot table where I also like to
highlight row where the total is?

thanks.
dineshI