Macro on blank ROWS

[Jacky01]

Hi, I actually have two requests, please could someone assist?

I want to colour all blank rows in a spreadsheet yellow and bold. somehow I am just not getting it right.

[ragulduy]

well you could use conditional formatting to do this.

highlight the rows you want it to apply to and with A1 active apply the conditional format rule with a formula:
=COUNTIF(1:1,"<>")=0
then set to yellow fill for true.

However, it seems redundant setting blank rows to bold, as they will be empty. So I'm guessing you want to permanently change the format rather than a conditional format, in which case:

Please Login or Register  to view this content.

which will change the colour of all the empty rows:

Please Login or Register  to view this content.

which will change back rows that were coloured and are no longer empty

[Jacky01]

Thank you so much!!! Your first macro has worked like a charm!!!! Yes, the bold is to prepare the cells in the blank rows for totals to follow, which brings me to my next question. I would like to add totals automatically to certain collums (I will demonstrate)

2014-07-16 1,28 0:13:25
2014-07-16 330,22 4:54:51
2014-07-16 46,78 1:00:39
2014-07-16 0,17 0:06:31
2014-07-16 10,49 0:35:50
2014-07-16 473,65 6:11:47
862,59 13:03:03 (This is the total row which is filled yellow and bold) and which I would like to automatically then add the total
2014-07-17 272,27 3:15:08
2014-07-17 73,89 0:59:10
2014-07-17 31,69 0:26:50
2014-07-17 249,27 4:17:11
2014-07-17 1,10 0:08:58
2014-07-17 12,96 0:22:21
2014-07-17 1,56 0:09:47
2014-07-17 7,23 0:23:49
2014-07-17 0,69 0:02:53
2014-07-17 0,19 0:02:34
2014-07-17 11,67 0:16:54
662,53 10:25:35 (This is the total row which is filled yellow and bold)2014-07-19 8,76 0:22:22
2014-07-19 7,14 0:22:44
15,90 0:45:06

[Jacky01]

Picture1.png

This is what it actually looks like

[ragulduy]

Hi,

Please upload a workbook, rather than a picture, and I'll have a go. I would guess you would do something like:

Please Login or Register  to view this content.

Where A is the column you want the sum in.

[Jacky01]

Hi the macro works perfectly although it gives me a #Name? error where the total s should be

[ragulduy]

Try:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

I think this line:

Please Login or Register  to view this content.

Should be:

Please Login or Register  to view this content.

[Jacky01]

Thank you thank you, ragulduy, you are an absolute genius!!!