Conditional formatting formula for subtotals with colours in a requested range

Hi All

I have a spreasheet for doing costing with formula,however I am looking a formula in conditional formating in doing subtotals with same row colour in bold .

The spreadsheet is big, for the moment doing same with paste special and coloured subtotals rows in bold and red and using format table

Thus I am looking a formula in conditional formating in doing subtotals,alternate rows with their respective header change colour and the whole subtotals rows bold in red for easy reading .

See annexed for more explicit details

thanks

Hello
If the word 'Total' is consistently at the end of each cell in column A, the the following Conditional Formatting formula applied to your table should work:

Formula:

Please Login or Register  to view this content.

Format Red & Bold. However, in your 'Expected results' tab there are two lines 37 & 39 that have the word total and aren't coloured red, is there any reason for this?

DBY

Hi

Line 37 and 39 are included , I omit these by error.

thanks it works but also I need to hightlight the whole row that is row F6,F18,F22 and so on.

Could you help me on this

32082090 PAINTS NL Total 192 289.92 1

34022090 CLEANING PREPARATION FR Total 79 340.302492 2

Hello
It does highlight the entire row if you select your whole table A2:G40 and then apply the Conditional Formatting formula.

DBY

Hi

Thanks for your help it works

Thank you a lot
it works