Conditional formatting with borders

Hello,

I have to do conditional formatting based on first two columns if cell contains "Total" then border for all cells. I have lots of sheets which are basically paste special from pivot tables. When I did paste special, then all formatting are gone from pivot tables.

I just need to add borders where Totals are in either Column A or Column B. Can there be conditional formatting done, so that all sheets are selected at once and formatted together after paste special from pivot tables.

For example in attached sheet, I need borders from Column A to P based on "Total" in column A & B.

Thanks!

So you want border if a cell contains something in it?

Highlight Columns A through P
Click on Conditional Formatting
New Rule
Click on Format cells that only Contain
In box underneath Format only cells with
Click on drop-down box and select No Blanks
Click on Format
Click on Border - then Outline
Click on OK and OK

Select the cells you want conditionally formatted based on cells A12 and B12. With those cells selected, add the formatting condition with formula condition

case-sensitive

Formula:

Please Login or Register  to view this content.

case-INsensitive

Formula:

Please Login or Register  to view this content.

and set the format to display borders.

See this example based on your sample workbook.

Hello,

Thanks for replying. When I used the formula =OR(SUBSTITUTE($A$12,"Total","")<>$A$12,SUBSTITUTE($B$12,"Total","")<>$B$12, the borders are coming in all rows. See attached sample file. Can you please check what I am doing incorrectly as borders should be only with Totals.